I noticed today that JavaScript Date values (the number of milliseconds
since the Unix epoch) degrade to second precision when converted to
Julian date values and back using naive SQLite date/time function calls,
for example:
sqlite> SELECT strftime('%s', julianday(1219441430151/1000,
'unixepoch')) * 1000;
1219441430000
I suppose this is because "Unix has no tradition of directly
representing non-integer Unix time numbers as binary fractions."
<http://en.wikipedia.org/wiki/Unix_time>
Is there another way to preserve this information besides taking the
cumbersome additional step of constructing an intermediate ISO 8601 time
string from the JavaScript Date value in JavaScript and then converting
that to the Julian date (and back the same way)?
-myk
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
