Date Format Question

Hi

I do receive a date from a text box with this format:
dd/mm/yyyy

And i am inserting into Postgresql Database usign
(eg.):
INSERT INTO Mycalendar (Date) VALUES
(to_date('31/12/2005','mm/dd/yyyy')).

But for the "day" values above 10 (wich have not a
zero on his front) the month gets in the day place in
the database so :
31/12/2005 wich was suposed to be stored in this
format 2005-31-12

Is being stored in this format : 2005-12-31

How can i store the date in the right
format:(2005-31-12) ?

Thank´s in advance



Ângelo Marcos Rigo
AMR Informática
(51) 3348 0870
Rua Pe. Alois Kades 400/210
Porto Alegre /RS/Brasil
http://amr.freezope.org
angelo_rigo@yahoo.com.br










_______________________________________________________
Yahoo! doce lar. Faça do Yahoo! sua homepage.
http://br.yahoo.com/homepageset.html