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

Collapse
14: Response to to_char(now(), 'YYYY') and time zones (response to 1)
Posted by Dan Wickstrom on 04/12/01 04:05 PM
Use relative times: 

openacs4=# select to_char(substr(now() at time zone 'utc',1,19)::timestamp + '1 month'::interval,'MM');
 to_char 
---------
 05
(1 row)

openacs4=# select to_char(substr(now() at time zone 'utc',1,19)::timestamp + '1 year'::interval,'YYYY');
 to_char 
---------
 2002
(1 row)