All Questions
Tagged with unix-timestamp date
279
questions
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
...
- 1
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 ...
- 354
0
votes
0
answers
53
views
How to fetch the date of the file from the folder in UNIX Shell Script?
I am beginner to Shell Script.
Just want to know how to fetch date of the file from the properties in the UNIX Shell Script?
When I put 'ls -lrt' , could fetch the date where as for last six months we ...
- 214
1
vote
0
answers
56
views
How do I properly collect user options to form a unix timestamp?
I have been attempting to format this code correctly in order to display an accurate UNIX time stamp.
The Code:
} else if (interaction.commandName === 'updateraidtime') {
const month = ...
- 31
0
votes
1
answer
79
views
PervasiveSQL Database dates conversion
I'm working on tables obtained from a PervasiveSQL database and I have some trouble managing dates.
In some of the fields dates are recorded in the format we use in Italy, dd/mm/yyyy, but in others ...
- 1
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 ...
- 995
0
votes
0
answers
365
views
Convert 10 digit number from Legacy system to Date in SQL
I am converting data from a legacy system to SQL. I got to convert a 10 digit number (e.g. 1419120000) to SQL DateTime. I am able to do so using dateadd(second,1419120000,'1970-01-01'). This function ...
- 33
1
vote
1
answer
43
views
Unix time to Date in R
I need to convert a vector of dates from Unix Time to Date format using R. For more context, this dates come from Sentinel-2 satellite imagery time series with one image every five days. The time ...
- 307
1
vote
1
answer
670
views
Get Epoch/ Unix timestamp from Zoned Datetime in Java
I have to convert the birth date of people born in USA to Epoch and store it in database. Right now I am getting birth date from a legacy system in two different formats: yyyy-MM-dd HH:mm:ss & dd-...
- 1,417
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 ...
- 1,060
0
votes
1
answer
828
views
How to calculate timestamp from UNIX UTC for a date that is not my timezone
I am developing a weather app and I'm trying to retrieve the sunrise and sunset times. These values come in UNIX UTC format and I'm able to transform them into date and time, but the time always seem ...
- 227
0
votes
2
answers
44
views
Time/Data Conversion to Unix
Im trying to convert a specific date to unix, but unfortunatelly something seems to be missing/wrong.
Any help, will be highly appreciated.
releasedate='Jul 07 2022 02:00:00'
releasedate2 = datetime....
- 5
1
vote
2
answers
1k
views
UTC time is incorrectly displayed as local time
I've found that some dates (at the moment I only found this error with some before-epoch dates) add an hour of difference from UTC.
Local time is GMT-3
First time I see it was in Javascript
> new ...
- 1,068
0
votes
1
answer
142
views
Filter SQlite unix timestamp data on hh:mm:ss part
I have the following records in my SQlite DB.
**SESSION** **DATETIME **BID** ASK**
25e309b5-eecd-49f7-a1e4-0a77d4804978 1650240126 1979.74 1979.99
25e309b5-eecd-...
- 117
0
votes
0
answers
264
views
How to get the year, day, seconds, and milliseconds from a Unix timestamp (language agnostic)?
Not looking for the environment-specific date methods like this for calculating these date fields, but how do you isolate them from a Unix timestamp such as now, which was 1650045773120? It is in ...
- 77.9k