"Carlos H. Reimer" <[EMAIL PROTECTED]> writes:
> select to_date('16/10/2006','DD/MM/YYYY');
> to_date
> ---------------------
> 2006-10-16 00:00:00
> (1 row)
Um... what have you done to to_date()? The standard version returns a
date, not a timestamp:
regression=# select to_date('15/10/2006','DD/MM/YYYY');
to_date
------------
2006-10-15
(1 row)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
