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