Revision as of 15:36, 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	15	b420ebc0-e26e-1389-8000-000000000000	`DATETIME((([time] + 122192928000000000) / 10000000) - 11644473600, 'unixepoch')`
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')`

@@ Line 81: / Line 81: @@
 | 100 Nanosecond
 | [https://www.rfc-editor.org/rfc/rfc4122#section-4.1.4 Integer]
-| 15
+| style="text-align:right;" | 15
 | b420ebc0-e26e-1389-8000-000000000000
 | <code>DATETIME((([time] + 122192928000000000) / 10000000) - 11644473600, 'unixepoch')</code>