Questions tagged [unix-timestamp]
The number of seconds between a particular date and the Unix Epoch on January 1st, 1970
2,346
questions
-1
votes
1
answer
118
views
How to extract TimeStamp in correct format from XML in XLS Report
i am having problem with extracting Timestamp from XML report, generated by JMeter using JS and i am using its values in XLS report.
i have tried multiple ways to extract Timestamp values in seconds ...
- 1
0
votes
2
answers
166
views
Windows command prompt showing incorrect time since epoch
I am trying to monitor my app launch time on a Windows machine using command prompt. This is how I launch my electron app
powershell -command "(New-TimeSpan -Start (Get-Date "01/01/1970"...
- 119
0
votes
2
answers
91
views
Pandas to_datetime method giving incorrect year when converting Unix Timestamp
When using to_datetime method of Pandas Dataframe to convert a Unix Timestamp to a Formatted DateTime in a column of data collected from a Data Logger I get the wrong year by 20 years. I have checked ...
- 61
0
votes
1
answer
84
views
select column based on date interval converted from unix timestamp in Oracle sql
I have to run a select from table based on a condition from a column with a unix timestamp value. I have converted the value into a date in order to apply my condition. The query is something along ...
- 13
-2
votes
1
answer
206
views
How can I convert a day, DD-MM-YYYY HH:MM:SS +XXXX to unix time in Python?
I'm working with a timestamp that is formatted Thu, 04 Jan 2024 18:25:01 +0000 but I need it in Unix time. I've looked at several library functions and cannot figure out how I can achieve this. How ...
0
votes
0
answers
62
views
Unix timestamp conversion
I have a datetime in this format "frame.time": "Dec 7, 2023 06:55:20.320000000 Mitteleuropäische Zeit" in my json script and I want to extract this json script into .csv so I want ...
-1
votes
1
answer
75
views
Modbus TCP Server Timestamp Convert Problem
I wanna convert data of Error Code 1 Date Time H (0x6578) and Error Code 1 Date Time L (0x7AE) to timestamp from Modbus TCP Server, but the result I got was "5/16/1973 Wednesday 11:27:42", ...
- 1
1
vote
1
answer
57
views
How do I assign an array time ranges to each day of the week?
What I want to create using the my code is an array of 7 objects as illustrated below:
(7) [{…}, {…}, {…}, {…}, {…}, {…}, {…}]
These objects are 7 because they represent each day of the week, as seen ...
- 1,648
0
votes
1
answer
198
views
Convert normal human readable datetime to unix timestamp in Snowflake
I have created an SQL model in snowflake that gives a several outputs among those ones, I have two columns that are the next :
The first column: called last_used that gives a human readable datetime ...
- 417
1
vote
0
answers
45
views
Trying to find out how many years between unix timestamps?
I found some examples when searching, but couldn't find an example to show how many years are in-between unix timestamps.
I tried the following code:
$bought = $row['purchase_date'];
$sold = $row['...
0
votes
0
answers
12
views
Removing "01" Prefix from Timestamps in Plot in Python
I am currenlty working on a plot containing two sets of data and fitting linear regression to them. I have a problem with timestamps that i need to have in UTC on the plot (originally in unix). I ...
- 11
6
votes
1
answer
5k
views
How do you get the UTC time offset in Python now that utcnow() is deprecated? [duplicate]
I need the time difference in sec between my current location and UTC. It worked so well with (example timezone Berlin, UTC+1h) :
import datetime
datetime.datetime.utcnow().timestamp(): 1699017779....
- 423
0
votes
0
answers
269
views
Converting UNIX Timestamp in Excel but which timezone?
I've got a data with unix timestamps as the date/time format. I convertet the timestamps with the following line: = A1/86400000+25569 and fomatted the column to the Excel date/time format dd.mm.yyyy ...
- 1
0
votes
0
answers
62
views
LinkedIn API "Time-Bound Follower Statistics" Data Discrepancy
I am currently working on a project that involves retrieving "Time-Bound Follower Statistics" data from the LinkedIn API. However, I have noticed a significant discrepancy between the data ...
0
votes
1
answer
128
views
PySpark Unix Time to yyyy-MM-dd HH:mm:ss.SSS
I want to convert epoch time in miliseconds to yyyy-MM-dd HH:mm:ss.SSS using PySpark. I tried below but I get weird conversion.
srcdf.withColumn("createdTime",from_unixtime(col("...
- 103