All Questions
Tagged with unix-timestamp epoch
95
questions
-2
votes
1
answer
187
views
What are all the known serialization formats of (unix) epoch time?
So, the basic definition of epoch time (similar to 'unix time', but not exactly: see below) and what it means is clear. However, nowhere on the wikipedia page or on any other resource I can find is it ...
0
votes
1
answer
95
views
Working with shell scripts on hp-ux and need to convert time to epoch using date command. How to solve bad format character -s error?
To Work on few shell scripts and I need to get the time in terms of epoch in hp-ux
I tried using
date +%s
but i got bad format character - s error
i am allowed to use -u and -a options with date ...
0
votes
2
answers
180
views
How to convert current date time into time zone format using PowerShell?
I am trying to convert the current date time into the format "2023-05-25T09:51:55" using time zone Central European Time using PowerShell but getting below error.
**Exception calling "...
0
votes
2
answers
261
views
Date Time Conversions in PySpark
Can someone please explain me how the below epoch time
epoch time/unix-timestamp :1668443121840
converts to the date : 2022-11-14T16:25:21.840+0000
How is the conversion taking place and ...
0
votes
1
answer
271
views
Azure Delta Load won't recognize Epoch timestamp (ms) as Watermark Column Name
I am trying to perform a delta load (incremental load) with Azure Data Factory from SQL Server to Blob Storage. My tables have an updateStamp column that is Epoch Time in milliseconds, numeric(19,0) ...
0
votes
1
answer
151
views
Pandas data_range to epoch in miliseconds
I am generating a data range using pandas and after transforming to epoch, however I realized that the mktime function is given me my local timezone and not UTC.
How do I get an list of dates in UTC ...
0
votes
1
answer
410
views
How to change timezone from GMT+0 to GMT+2 of this Unix epoch time (Milliseconds) conversion Query?
I have a database that stores Unix Epoch time stamps in milliseconds. I use this code to translate it to something readable (which I use in a GUI I'm working on). However this results in a data set in ...
0
votes
2
answers
509
views
Powershell string to unix time with correct timezone
I'm collecting a timestamp value and trying to transform it to a Unix format.
To do that, I'm using ParseExact method, like so:
$FILETIME = "20220709101112"
$EPOCHTIME = [datetime]::...
0
votes
0
answers
14
views
datetime not matching with epoch timestamp [duplicate]
I have below code where I am getting current datetime in utc and then converting it to epoch.
ct = datetime.datetime.utcnow()
f = ct.replace(microsecond=0) # removing the microseconds from ct
print(&...
1
vote
0
answers
2k
views
Pseudo-code algorithm to calculate the Unix epoch timestamp from given date and time?
Given UTC date and time as year, month, day, hour, minute, second, I was wondering about a pseudo-code algorithm to calculate the corresponding Unix epoch timestamp.
There are 60 seconds in a minute, ...
0
votes
1
answer
850
views
When exporting facebook messenger data, is it possible to convert the filename into datetime?
I am not sure if this is even possible. I have used the export feature on FB to download Messages and all of the file names are basically a long string of numbers. I've searched all over the web to ...
1
vote
0
answers
227
views
React.js Epoch timestamp to display only time AM PM
I am doing a personal React.js project. I have a map that gives me as one of the values an Epoch timestamp. I want to display only the time of that timestamp as AM or PM, but I can't figure it out. ...
0
votes
1
answer
1k
views
How to get yesterday's date in Epoch time? [python]
I can easily get the yesterday date like this:
from datetime import datetime, timedelta
yesterday = datetime.now() - timedelta(1)
x= datetime.strftime(yesterday, '%Y-%m-%d')
How can I do the same for ...
2
votes
1
answer
911
views
Converting EPOCH UNIX time format using addToTime in Power Automate
I'm using power automate flow to query the Dynatrace REST API, which returns JSON formatted output.
startTime is returned in EPOCH UNIX time format and I'm using this expression to convert it into a ...
1
vote
1
answer
172
views
Why is year from my timestamp centuries off? PHP/Wordpress
I've googled this a bunch and got nothing so I'm hoping y'all can help.
I'm calling this API (https://api.metals.live/v1/spot). I'm converting the timestamp using PHP's date() function but I get back ...