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