원본출처 : 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
|