brianchan.us
Convert a bare timestamp to local time in PostgreSQL
Very often in old databases a timestamp column does not have the timezone info. This becomes an issue when the business gets bigger and crosses different timezones. The above sample query assigns t…