On May 3, 4:11 pm, Phrogz <[email protected]> wrote: > I have an old SQLite DB that I've moved to PostgreSQL. Many entries > are timestamped, and I'm trying to understand how to query the DBs > correctly. During investigation, I've come across these results, and I > don't know how to interpret them. > > Here's a test case with sanitized output:http://pastie.org/944406 > > Is Sequel using -0600 in the queries because of Daylight Savings Time? > How is SQLite returning 'false' values when mapped, the last three > records that are clearly not within the requested time?
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. Sequel does use timezones in timestamps on SQLite, at least in recent versions. Jeremy -- 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.
