원본출처 : http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=136

Submitted on: 04-12-2001

Description:

Several tips to convert to different timezones, extract some date fields and do some calculations with the dates

Code:

test=# select to_char(now(),'yyyy-mm-dd hh24:mi') at time zone 'utc';

timezone

------------------------

2001-04-12 14:09:00+00