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

Collapse
7: Response to to_char(now(), 'YYYY') and time zones (response to 1)
Posted by Simon Carstensen on 04/12/01 12:45 PM
It doesn't seem to be working after all: 

=#select to_char((select now() at time zone 'utc')::timestamp,'HH24:MI');
to_char 
---------  
03:43
(1 row)

=#select now() at time zone 'utc';
        timezone
------------------------
2001-04-12 10:43:51+00
(if it was working, the time should be the same)