Identify SQL time format
The TIMESTAMP
values are likely from Apple Core Foundation code based on an epoch of Jan 1, 2001 00:00:00 GMT.
Time Utilities - Core Foundation | Apple Developer Documentation
Core Foundation measures time in units of seconds. The base data type is the
CFTimeInterval
, which measures the difference in seconds between two times. Fixed times, or dates, are defined by theCFAbsoluteTime
data type, which measures the time interval between a particular date and the absolute reference date of Jan 1 2001 00:00:00 GMT.
Wolfram Alpha: January 1, 2001 00:00:00 GMT + 498586831.475129 seconds
Result: 4:20:31 GMT | Wednesday, October 19, 2016
Wolfram Alpha: January 1, 2001 00:00:00 GMT + 497469155.776235 seconds
Result: 5:52:35 GMT | Thursday, October 6, 2016
Prior answer (still relevant)
Without more context, you must look for conversions that make sense.
The integer part is a reasonable number of seconds, and the decimal places could represent microseconds.
Option 1: UNIX Epoch
Wolfram Alpha: 498586831.475129 seconds since unix epoch
Corresponding Gregorian time and date:
4:20:31 pm UTC | Saturday, October 19, 1985
Is a date in 1985 reasonable for that record?
Option 2: Alternate Epoch
Wolfram Alpha: 498586831.475129 seconds ago
Result:
9:43:46 pm EDT | Sunday, July 22, 2001
Perhaps, the field represented seconds since January 1, 2000 or January 1, 2001.
Option 3: Duration
Wolfram Alpha: 498586831.475129 seconds
Unit conversions:
8.3097805245855×10^6 minutes
138496.342076425 hours
5770.680919851 days
15.799587725555 average Gregorian years
Is this amount of time relevant to the record?
EDIT: With your additional context (of the date being between 2007 and the present), "Option 2: Alternate Epoch" becomes the most reasonable, and this record occurs about 15.8 years afterwards.