This page (revision-1) was last changed on 29-Nov-2024 16:16 by UnknownAuthor

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note

Page References

Incoming links Outgoing links
Time And Epochs
Time And Epochs

Version management

Difference between version and

At line 1 added 32 lines
[{TableOfContents}]
!![Overview Dates Time And Calendars]
Some information on [Overview Dates Time And Calendars].
! [Microsoft TIME]
[Microsoft TIME] is different.
! [UUID]
The [timestamp], as used in the [UUID] [RFC 4122] is a 60 bit value, representing the number of 100 [nanosecond] intervals since 15 October [1582|Year 1582] 00:00:000000000
This guarantees that there would be no duplicates in UUID until 3400 AD. (Then What? ;-) )
! [Unix Time]
[Unix Time] is a [NumericDate]
! [OpenVMS]
[OpenVMS], it's 00:00:00 of November 17, [1858|Year 1858] (base date of the [United States Naval Observatory]'s ephemerides)
! Macintosh
Macintosh, it's the midnight beginning January 1 [1904|Year 1904]. ([MacOS Epoch])
[System time] is measured in [seconds] or [Tick] past the [epoch].
! [Google] Sheets
[Google] Sheets uses a form of [epoch] [date] that is commonly used in spreadsheets. The whole number portion of the value (left of the decimal) counts the days since December 30th [1899|Year 1899]. The fractional portion (right of the decimal) counts the time as a fraction of one [day]. For example, January 1st [1900|Year 1900] at noon would be 2.5, 2 because it's two days after December 30th, [1899|Year 1899], and .5 because noon is half a day. February 1st [1900|Year 1900] at 3pm would be 33.625.
Note that Google Sheets correctly treats the year [1900|Year 1900] as a common year, not a leap year.! Interesting Links:
* [Epoch (reference date)|http://en.wikipedia.org/wiki/Epoch_(reference_date)]
* [Java Dates Timezones And Calendars]
!! More Information
There might be more information for this subject on one of the following:
[{ReferringPagesPlugin before='*' after='\n' }]
This page (revision-1) was last changed on 29-Nov-2024 16:16 by UnknownAuthorTop