Difference between revisions of "Time Epochs"
Jump to navigation
Jump to search
(→Epochs) |
|||
| Line 37: | Line 37: | ||
| <code>DATETIME(([time] / 1000000000) + 978307200, 'unixepoch')</code> | | <code>DATETIME(([time] / 1000000000) + 978307200, 'unixepoch')</code> | ||
|- | |- | ||
| − | | | + | | Chrome |
| <code>01 Jan 1601</code> | | <code>01 Jan 1601</code> | ||
| 1 Microsecond | | 1 Microsecond | ||
| Line 77: | Line 77: | ||
| <code>DATETIME([time] / 1000000000, 'unixepoch')</code> | | <code>DATETIME([time] / 1000000000, 'unixepoch')</code> | ||
|- | |- | ||
| − | + | | UUID Type 1 | |
| <code>15 Oct 1582</code> | | <code>15 Oct 1582</code> | ||
| 100 Nanosecond | | 100 Nanosecond | ||
| Line 85: | Line 85: | ||
| | | | ||
|- | |- | ||
| − | + | | Windows COM<br />Excel OADate<br />OLE Automation Date | |
| <code>30 Dec 1899</code> | | <code>30 Dec 1899</code> | ||
| 1 Day | | 1 Day | ||
| Line 93: | Line 93: | ||
| <code>DATETIME(([time] * 86400) - 2209161600, 'unixepoch')</code> | | <code>DATETIME(([time] * 86400) - 2209161600, 'unixepoch')</code> | ||
|- | |- | ||
| − | + | | Windows FILETIME | |
| <code>01 Jan 1601</code> | | <code>01 Jan 1601</code> | ||
| 100 Nanosecond | | 100 Nanosecond | ||
| Line 101: | Line 101: | ||
| <code>DATETIME(([time] / 10000000) - 11644473600, 'unixepoch')</code> | | <code>DATETIME(([time] / 10000000) - 11644473600, 'unixepoch')</code> | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 07:05, 13 June 2026
Epochs
Here's some of the time formats that Truxton can handle. Wikipedia has a better list. The Truxton software uses FILETIME for all time calculations.
| Name | Epoch | Clock Tick | Data Type | Digits | Sample | SQLite |
|---|---|---|---|---|---|---|
| .Net Ticks | 01 Jan 0001
|
100 Nanosecond | Integer | 18 | 637702123019480000 | DATETIME(([time] / 10000000) - 62135596800, 'unixepoch')
|
| Apple NSDate Apple Cocoa Core |
01 Jan 2001
|
1 Second | Integer | 9 | 656351501 | DATETIME([time] + 978307200, 'unixepoch')
|
| Apple NSDate Apple Cocoa Core |
01 Jan 2001
|
1 Nanosecond | Integer | 18 | 656351501948449001 | DATETIME(([time] / 1000000000) + 978307200, 'unixepoch')
|
| Chrome | 01 Jan 1601
|
1 Microsecond | Integer | 17 | 13279089101948000 | DATETIME(([time] / 1000000) - 11644473600, 'unixepoch')
|
| Unix | 01 Jan 1970
|
1 Second | Integer | 10 | 1634658701 | DATETIME([time], 'unixepoch')
|
| Unix | 01 Jan 1970
|
1 Millisecond | Integer | 13 | 1634658701948 | DATETIME([time] / 1000, 'unixepoch')
|
| Unix | 01 Jan 1970
|
1 Microsecond | Integer | 16 | 1634658701948449 | DATETIME([time] / 1000000, 'unixepoch')
|
| Unix | 01 Jan 1970
|
1 Nanosecond | Integer | 19 | 1634658701948449001 | DATETIME([time] / 1000000000, 'unixepoch')
|
| UUID Type 1 | 15 Oct 1582
|
100 Nanosecond | Integer | |||
| Windows COM Excel OADate OLE Automation Date |
30 Dec 1899
|
1 Day | Float | 5+ | 44488.1609021759 | DATETIME(([time] * 86400) - 2209161600, 'unixepoch')
|
| Windows FILETIME | 01 Jan 1601
|
100 Nanosecond | Integer | 18 | 132790891019480000 | DATETIME(([time] / 10000000) - 11644473600, 'unixepoch')
|
