by Zizi64 » Fri May 19, 2017 4:58 pm
Here is some clarification (I hope):
- The Date, the Time and the datetime values are numbers in the AOO/LO, in the Windows and in the Linux, and in the Unix operating system.
- The date type strings are formatted numbers (for Windows type datetime) :
Formatted string "2017 may 19. 16:43:17" = unformatted number 42874,69672
The date part equals
2017 may 19 = 42874
and the time part
16:43:17 = 0,69672
- All of the "pure" time values contain a date part with value 0.
- The 0 value represents the base Date/Time value in all of the system.
- The windows dates are on day basis (the elapsed days since the base date are the integer part of a DateTime value, and the fraction represents the time value)
- There are three different base dates in the Windows computer world: it is a heritage from the older systems, and softwares:
1899 dec 30.
1900 jan 01.
1904 jan 01.
- The default base date in the AOO/LO (on Windows) is the first in the list above
- The Unix dates are on second basis: it is a long type integer number, represents the elapsed time (in second unit) since the Unix base date
- The base date on Unix is 1970 jan 01.
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.6 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.0.2 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.