Re: [BUGS] date_trunc problems crossing DST border

2004-10-31 Thread Tom Lane
"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

[BUGS] date_trunc problems crossing DST border

2004-10-30 Thread Matthew \"Cheetah\" Gabeler-Lee
[ 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