Ian Strascina <[email protected]> wrote:
> So is this a sqlite bug in that inconsistent results are coming from queries
> that should be functionally equivalent according to the above documentation
Realize that SQLite doesn't have a date or datetime data types. All the
calculations are performed on strings, all comparisons are regular string
lexicographical comparisons. If you are consistently using certain string
formats for representing dates and times, string comparisons just happen to
order dates correctly.
Thus, 'X Y' < 'XTY' for any substrings X and Y, whether they happen to
represent date and time or otherwise.
For consistent results, you could either change the format of your data to
match that produced by datetime (that is, 'YYYYMMDD HH:MM:SS') or use
strftime('%Y-%m-%dT%H:%M:%S-00:00') in place of datetime().
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
