Re: RES: Dates rejected - Mailing list pgsql-general

"Carlos H. Reimer" <carlos.reimer@opendb.com.br> 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