List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 6 2001 1:20pm
Subject:Re: Help about date conversion ...
View as plain text  
At 9:27 AM -0300 9/6/01, Amilton Martins wrote:
>I want to write date type in the format "DD/MM/YYYY" to the database?
>Can I do this with some parameter to mysql.ini?

No.  For storage, you must convert it to CCYY-MM-DD format.
For display, you can format it to the style you want using
DATE_FORMAT(d,'%d/%m/%Y').

>
>**************************
>Amilton Martins
>Infosoft Informática Ltda.
>www.infosoft.inf.br


-- 
Paul DuBois, paul@stripped
Thread
Re: Help about date conversion ...Amilton Martins6 Sep
  • Re: Help about date conversion ...Gerald Clark6 Sep
  • Re: Help about date conversion ...Paul DuBois6 Sep
  • Re: Help about date conversion ...Bill TQO Adams6 Sep