I'm creating a new database to keep track of time difference between logins
and logoffs for a particular system.
I have the following query:
select NodeOpened,
JulianDay(NodeOpened),
JulianDay('now')
from EventEntry
where NodeClosed is null
The results are:
NodeOpened JulianDay(NodeOpened) JulianDay('now')
2019-09-03 19:29:15.000 43711.8119791667 2458734.32840103
2019-09-03 19:52:24.000 43711.8280555556 2458734.32840103
2019-09-03 20:08:54.000 43711.8395138889 2458734.32840103
Reading the Wiki on Julian Day (That the SQLite DateTime formats provides)
I understand why JulianDay is such a large number (Counting days back from
the BC era), but I'm not understanding why the NodeOpened is such a small
number and 'now' is such a huge number?
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
