Chris wrote: > > The following bug has been logged online: > > Bug reference: 2046 > Logged by: Chris > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0 > Operating system: Windows > Description: defective date_trunc > Details: > > Postgresql 8.0 > > select date_trunc('week',TO_DATE('2005-01-01','yyyy-mm-dd')) > > > result > > > "2006-01-02 00:00:00+01"
Are you on 8.0.4? If not, you need to upgrade because we fixed this. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq