>Better yet, either one of the datetime() or julianday() functions
>(with the same one used consistently in all places) will work best
>for comparison since the output for either one sorts correctly
>against itself. strftime() should be saved for display formatting.

Only for a timestring with a constant offset from UT1.  The default is a fixed 
offset of 00:00, (Zulu, GMT, or UT1, whatever you want to call it).  Some 
people erroneously call this UTC but it is not.  UTC has a variable number of 
seconds in a day.  Zulu/GMT/UT1 have 86400 seconds in a day, never more and 
never less.  

If you store "localtime" or an "instant time" with an offset from GMT, then it 
cannot be sorted (unless all the offsets are the same, that is).

The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.

sqlite-users mailing list

Reply via email to