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

Collapse
Posted by Simon Carstensen on
Thanks Dan, I think I get the idea now.

Now that we're at it, can I ask you one more thing? Say I've selected the current month in the time zone 'utc', now, is there a way I can select the next month or the month before. So if I fx selected "12" (using your query) is it then possible to make Postgres compute the next month - that would be 01. Or the next year if it's the year I've queried for, or the day?