Forum OpenACS Q&A: Response to Has anyone reported/fixed a bug with trunc(datetime,varchar) yet?

No, I hadn't noticed this.  The only site I personally run using the
calendar stuff is on PG 7.1, and your examples work there.  "trunc()"
is a PL/pgSQL routine we provide, but it simply calls the PG internal
"date_trunc" routine, at least in the current sources (check your
version of postgres.sql to make sure this is true if you're using the
3.2 release).