"Matthew \"Cheetah\" Gabeler-Lee" <[EMAIL PROTECTED]> writes:
> [ PostgreSQL 7.4.5, Linux (Debian sarge) ]
> The date_trunc function is making some off-by-one errors when working at
> a DST border.
> => select date_trunc('minute', '2004-10-31 01:00:00-05'::timestamptz);
>date_trunc
[ PostgreSQL 7.4.5, Linux (Debian sarge) ]
The date_trunc function is making some off-by-one errors when working at
a DST border.
=> select date_trunc('minute', '2004-10-31 01:00:00-05'::timestamptz);
date_trunc
2004-10-31 01:00:00-04
Expecting 2004-10-3