Questions tagged [unix-timestamp]
The number of seconds between a particular date and the Unix Epoch on January 1st, 1970
2,345
questions
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
1
answer
112
views
convert string type datetime values to specific format in pyspark
I have a pyspark dataframe having below types of date time values (string type) -
|text|date_filing|
|AAA|1998-12-22|
|BBBB|2023-08-30 12:03:17.814757+00|
|CCC|null|
|DDD|2017-11-28|
I want to ...
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
46
views
Convert "Unix Epoch Time" to human readable time using time.gmtime raises OSError "invalid argument"
Converting Unix Epoch time to readable time information. Trials are as per below. It throws an error "OSError: [Errno 22] Invalid argument". Looks like the method does not like the given ...
0
votes
1
answer
36
views
How to show date in 13-digit Unix Timestamp format in JSpreadSheet?
I have data, which contains date. It is saved in Unix Timestamp format. I am looking for a way, how to display this data in JSpreadSheet ("jspreadsheet-ce") so, that it looks like date (YYYY/...
0
votes
2
answers
27
views
Printf command adding extra space in the line
I am trying to create hdr record in unix script. I am using printf function to populate. printf statement added 2 spaces in the line.
I am using below code for that
REC_TYP="1"
SYS_ID=&...
3
votes
1
answer
621
views
Why is the constant 11644473600 used for converting FILETIME to Unix time?
I've been researching on how different operating systems represent time, as well as how to convert between them. I've read several pages that all describe a similar method for converting between ...
0
votes
0
answers
39
views
Huge discrepancy between file Mtimes from Rust and NodeJS
I've stumbled across a very unexpected issue, which is that I'm trying to download a file from a NodeJS server from Rust only if the destination file is older than the source. The mtime for the Source ...
0
votes
0
answers
653
views
Conversion of timestamp(long value) to date only(YYYY-MM-DD) in DBT
I'm trying to convert timestamp (long value) into date only (YYYY-MM-DD) with the below query.
SELECT
id,
scheme_name,
DATE(FROM_UNIXTIME({{'scheme_t'}})) AS scheme_date
FROM
...
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 ...
0
votes
1
answer
393
views
Date.now() and DateTime.now() returns different value in Flutter Client and NodeJS server
I am trying to implement a turn-based counter on my Flutter app with the NodeJS backend.
I am storing the timestamp of each turn on the server using Date.now() (which returns a timestamp).
The flow is ...
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
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
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 ...