Category Archives: PostgreSQL

Converting timestamps in PostgreSQL (again)

Revisited converting timestamps to UTC from different timezones. One way to do this is a variation on the PostgreSQL documentation on date/time functions, where epoch is used as a common unit: Gets the job done, but the following is cleaner: … Continue reading

Posted in PostgreSQL | Tagged , ,

Convert PostgreSQL timestamp without time zone to timestamp at UTC with ISO 8601 notation

There is a lot of hair-splitting on the subject, but the ISO-8601 standard allows for many variations in format. The most widely used places characters within the timestamp to indicate where the time portion of the stamp begins, and the … Continue reading

Posted in PostgreSQL | Tagged , , , ,