Postgres Pro
Downloads
Home   >   mailing lists

BUG #2046: defective date_trunc - Mailing list pgsql-bugs

From Chris
Subject BUG #2046: defective date_trunc
Date
Msg-id 20051115125948.86378F0C9D@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #2046: defective date_trunc  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: BUG #2046: defective date_trunc  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      2046
Logged by:          Chris
Email address:      termi@wp.pl
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"

pgsql-bugs by date:

Previous
From: "balamuralikn"
Date:
Subject: BUG #2044: OLEDB Driver error
Next
From: "Stephan Fischer"
Date:
Subject: [postgres] pgcluster