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

Thanks for the response - it seems to me that it might be the solution. But it isn't working.

I get:

ERROR: parser: parse error at or near "at"

I don't know how to give the subselect a name, nor how to fully qualify the argument to to_char (don't even know what that means)...Can you help me?

Yours,