Forum OpenACS Q&A: Response to to_char(now(), 'YYYY') and time zones

Collapse
5: Response to to_char(now(), 'YYYY') and time zones (response to 1)
Posted by Dan Wickstrom on 04/12/01 05:48 AM
Try this: 
openacs4=# select to_char((select now() at time zone 'utc')::timestamp,'YYYY');  
to_char 
---------  
2001 
(1 row)