On May 3, 6:35 pm, Jeremy Evans <[email protected]> wrote: > SQLite does not have real date or timestamp columns. You can use > SQLite date and datetime functions, but it's clunkier. If you just use > an inequality operator, SQLite does a lexicographic comparison.
:o But, even lexicographically the result is incorrect: "2010-04-15 00:57:14 -0700" < "2010-04-14 00:00:00.000000-0600" #=> false AH! But if I select that last record straight from the DB through SQLite, I get a value of: 2010-04-14T23:57:14-07:00 ...which I suppose makes sense given daylight savings time. OK, point proven yet again: SQLite is not the awesome little beast I sometimes think/hope it is. Thanks! -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
