Guilherme Silva <[EMAIL PROTECTED]> writes:
> Negative, i know what the to_date do.
I don't think you do, because you are feeding it input that it will
ignore --- the hh/mm/ss fields are just being thrown away.
regression=# select to_date('01042005000000', 'ddmmyyyyHH24MISS');
to_date
------------
2005-04-01
(1 row)
regression=# select to_date('01042005235959', 'ddmmyyyyHH24MISS');
to_date
------------
2005-04-01
(1 row)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
