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

Collapse
4: Response to to_char(now(), 'YYYY') and time zones (response to 1)
Posted by Don Baccus on 04/12/01 04:29 AM
Ugh...maybe the "at" clause follows the entire query and therefore can't be buried in a subquery...

I have no experience playing with timezone issues in PG, I'm afraid.  I suggest you go ask the PG folks directly.  If they figure out a way to do this in a single query, let us know, OK?