Re: Error in date_trunc function?

...
> netquote=> select date_trunc('month', now());
>        date_trunc
> ------------------------
>  2001-10-01 00:00:00+04

This one rotated the time back to daylight savings time (the transition
date was in October), hence the one hour jump from now(). You certainly
would not want to somehow preserve a time zone into a date for which it
is invalid, right?

                     - Thomas