From: | Ângelo Marcos Rigo <angelo_rigo(at)yahoo(dot)com(dot)br> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Date Format Question |
Date: | 2005-12-05 18:33:13 |
Message-ID: | 20051205183313.91380.qmail@web34404.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)yahoo(dot)com(dot)br
_______________________________________________________
Yahoo! doce lar. Faça do Yahoo! sua homepage.
http://br.yahoo.com/homepageset.html
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Bax | 2005-12-05 19:11:46 | Re: Date Format Question |
Previous Message | Sugrue, Sean | 2005-12-05 17:26:06 | Re: Need help building SQL query |