Questions tagged [unix-timestamp]
The number of seconds between a particular date and the Unix Epoch on January 1st, 1970
2,345
questions
0
votes
0
answers
27
views
Kafka - migrating date from sqlserver (type: [datetime2](7)) to cockroach database table with "Timestamp" column
We have data stored in SQL Server and we are in need to migrate these data into cockroach database.
For this requirement, we are trying to set up a Kafka Pipeline to stream the data from source ...
- 1,861
0
votes
0
answers
56
views
Can we use SFTP GET command to retrieve the latest file from the directory? [duplicate]
I looked for a solution to retrieve the latest file from the directory and found in google in this very website.
latest_remote_file = $(ssh username@server_name 'ls -tr /path | tail -n 1')
scp -r ...
1
vote
1
answer
36
views
ls -rt | tail -n 1 does not work inside theJCL - piping symbol causing issue
I am facing a very strange problem, this command ls -rt | tail -n 1 works in linux server in the putty, but the same command when I give inside the JCL, for some unknown reason doesn't work.
//SYSUT1 ...
0
votes
2
answers
47
views
pandas date column to unix timestamp accounting for timezone and varying datetime formats
I have multiple data frames with a datetime column as a string. Datetime formats vary across columns in the dataframe or across dataframes. I want to get a unix timestamp that gets interpreted by an ...
- 370
1
vote
1
answer
146
views
get current UTC posix timestamp in better resolution than seconds in Python
I am trying to get a UTC posix timestamp in better resolution than seconds – milliseconds would be acceptable, but microseconds would be better. I need that as a synchronization for unrelated external ...
- 5,427
1
vote
2
answers
73
views
Convert UTC string datetime into millisecond UTC timestamp
In C++20, under UNIX systems (no portability is required), how do I convert a UTC string date time of the following format:
"2024-04-26T14:33:30.185Z"
into a UNIX UTC numeric timestamp ?
I ...
- 13
1
vote
1
answer
72
views
gorm how to declare a unix timestamp mills field that is not auto updated
We have a timestamp field in a database table, it should only be updated when a business event occurs, not upon create / every update.
There are examples of auto update at https://stackoverflow.com/a/...
- 1,320
1
vote
1
answer
92
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 ...
- 396
0
votes
1
answer
37
views
How can I calculate the Unix time taking into account the time zone?
Example:
SELECT
SESSIONTIMEZONE,
DT,
TRUNC( (DT - date '1970-01-01') * 86400) AS EPOCH_DT
FROM "test_table"
outputs
SESSIONTIMEZONE
DT
EPOCH_DT
Europe/Paris
1970-01-02 00:00:...
- 24.8k
1
vote
0
answers
25
views
sqlite3 update table value doesn't update timestamp
i'm using SQLite3 and i have a very simple table:
create table pulseCount (
pulses INTEGER NOT NULL,
timestamp DATETIME DEFAULT (1000*(strftime('%s','now')+mod(strftime('%f','now'),1)))
);
...
- 859
-2
votes
1
answer
35
views
Why does gradle think it's 1970?
When I execute the following code:
./gradlew clean
./gradlew --profile --offline --rerun-tasks assembleDevelopmentDebug
Is there any way to correct the time and date?
- 2,380
-2
votes
1
answer
175
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 ...
- 19.4k
-1
votes
1
answer
103
views
How do I make a JavaScript countdown using a Unix timestamp?
I am making a website that needs a countdown until a specific time, but I can't find anything that lets me input a Unix timestamp and gives the same countdown for all users, regardless of timezones.
I ...
-1
votes
1
answer
67
views
from_unixtime still displaying 19 hours past expected time
I currently have some cleaned data with new columns and formatted correctly, however the clause regarding from_unixtime is stumping me. I have tried the following:
from_unixtime(`time@timestamp`, '%H:%...
- 1
0
votes
0
answers
43
views
Function to format and display the time from a UNIX timestamp does not work in Safari Browser [duplicate]
This JavaScript code do not work in Safari Browser but works well in other browser.
Code returns time or date from timestamp value but not works in safari browser. In safari code returns: aN.aN.aN or ...
