CODEWITHSUNDEEP
sqlsql-serverdatetimetimestamp
navigator
navigator

Reputation: 1708

What kind of a timestamp is this?

We are extracting data from a third-party database for export. Two of the columns are Timestamp columns with some of the values displayed below. The timestamp is supposed to represent a UTC timestamp from a GPS device. They are stored as int data types in an SQL Server database.

enter image description here

Any idea how I can convert this timestamp (e.g. 368815303) to a regular date/time? The numbers seen should be very recent - i.e. within Sept 2020 and should represent the time down to the nearest second.

Upvotes: 0

Views: 231

Answers (2)

Gordon Linoff
Gordon Linoff

Reputation: 1269973

Based on the comment, you would use:

select dateadd(second, 368815303, '1980-01-06')

Based on your expectation, the base time appears to be about 2009-01-01, which suggests:

select dateadd(second, 368815303, '2009-01-01')

I am not familiar with any date/time epoch that uses that as the base time. It might be some bespoke system.

Upvotes: 1

Daxesh Radadiya
Daxesh Radadiya

Reputation: 73

It looks like some kind of epoch Unix timestamp.

Try this Epoch Converter which converts timestamp to human date

Upvotes: 0

Related Questions