All Questions
Tagged with unix-timestamp timestamp
401
questions
1
vote
1
answer
100
views
C# DateTime.Parse method losses nanosecond precision of the timestamp string
I need to convert an RFC-3339 formatted timestamp (e.g. "2024-01-04T14:30:00.119919872Z") to a unix nanosecond timestamp (e.g. 1704378600119919872). However, the C# DateTime structures ...
-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
vote
1
answer
147
views
Understanding Unix Timestamps and Time Zone Conversion in Python
I'm having trouble understanding Unix timestamps and time zone conversions in Python. I have a UTC datetime string ('2023-09-20T05:04:54') and latitude/longitude coordinates (around Toronto). I need ...
0
votes
0
answers
164
views
How can I edit the timestamp on remix to enable time acculation
I'm creating an application, that tracks users' listening time, and transfers a reward when they pass the average time threshold, how can I edit timestamp on remix to ease testing.
function ...
0
votes
1
answer
595
views
How to automatically convert UNIX Epoch Timestamp to Timestamp Column in Snowflake during ingestion
I'm doing some CDC from MySQL to Snowflake using Debezium and i'm running into an issue with UNIX Timestamps. Most of my timestamp columns are stored as UNIX Timestamps and when I'm loading the data ...
2
votes
1
answer
64
views
from_unixtime function not giving correct output in spark-sql
Note - I have looked over the internet, all the solutions are present in either python or scala but not in java.
I am reading data from a json file. In the file the time is given in unixtime format. I ...
0
votes
0
answers
44
views
Why does MariaDB's default cast timestamp to integer method works this way?
I recently noticed that casting a TIMESTAMP value:
SELECT CAST( timestamp_column_name AS int ) FROM table;
Which gives the same result as casting to a FLOAT, does not correspond to the 'natural' ...
0
votes
1
answer
770
views
Kotlin: how to get the start time of a day and end time of a day?
My input is unix seconds from epoch, which represents the date, that I need to work with, I need to convert the date to start time of a day and end time of a day of the same date, what are possible ...
1
vote
0
answers
103
views
How to send a unix timestamp of specific time of day using React?
In React 18.2.0, i am trying to send a timestamp data of today's 00.00 AM (and if it's necessary GMT +03.00 timezone) in HTTP request. To do this, i'm keeping timestamp data in a state named unixDate. ...
0
votes
1
answer
528
views
Using DateTime library in Remix to Convert Timestamp to DateTime format
If anyone is familiar with importing a library into Remix, then using it, maybe you can help. What i am doing pertains to this library...
https://www.npmjs.com/package/@quant-finance/solidity-datetime?...
0
votes
3
answers
205
views
Convert From MediaWiki Time Format To Unix Timestamp In PHP [duplicate]
MediaWiki (the free software behind Wikipedia) stores database timestamps in a unique binary(14) format for fields of the database. This is described further in their timestamp documentation.
The ...
-1
votes
1
answer
46
views
timestamp in PHP and Javascript
I have this timestamp how to convert it to unix timestamp
1.6749018E+12
Or is there any way to decode it in PHP let me know.
have good day!
My code
$t = '1.6749018E+12';
print date('H:i:s', $t);
Not ...
0
votes
1
answer
45
views
How can I add together 2 timeseries that have unix timestamps if the unix timestamps don't align?
I have Orderbook update data for 2 different assets and the updates happen at different unix timestamps, so the timeseries are both of different length and have different indexes. How should I go ...
1
vote
1
answer
2k
views
Why most API use ISO-8601 timestamp format over epoch? [closed]
I've seen a lot of projects where epoch format was used to represent dates. But as far as I know most of developers use ISO-8601 format for timestamp. I wonder what benefits ISO-8601 has over epoch?
I ...