I love Postgres' time handling, even more so whenever I have to handcraft time-based queries in other databases, like MongoDB (which is more often than I'd like

I love Postgres' time handling, even more so whenever I have to handcraft time-based queries in other databases, like MongoDB (which is more often than I'd like). Some things the author didn't mention that I like: * Timestamp with time zone string parsing: '2013-06-27 13:15:00 US/Pacific'::timestamptz * Timezone-aware to timezone-naive conversion (or vice versa): mytztime AT TIME ZONE 'US/Pacific' * I haven't used tstzrange yet, but it looks pretty powerful.