Date Format Question

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

Responses

Browse pgsql-novice by date

  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