Good Afternoon All
following the documentation available at
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
i wish to select a date using DD-MON-YY format but my format of '%y-%b-%d'
appears to be incorrect
mysql select DATE_FORMAT('11-10-09','%y-%b-%d') from DUAL;
Basicay, your date_format works like:
select DATE_FORMAT('YY-MM-DD','%y-%b-%d') from DUAL;
Martin Gainty mgai...@hotmail.com escreveu na mensagem
news:blu142-w2137936b18ae273dbd6cb1ae...@phx.gbl...
Good Afternoon All
following the documentation available at
To: mysql@lists.mysql.com
From: j...@consultorweb.cnt.br
Subject: Re: DATE_FORMAT parameter question
Date: Fri, 9 Apr 2010 12:56:46 -0300
Basicay, your date_format works like:
select DATE_FORMAT('YY-MM-DD','%y-%b-%d') from DUAL;
Martin Gainty mgai...@hotmail.com escreveu na mensagem
If you'll excuse the shameless plug: I once created a tool to help find
the exact parameters to use for PHPs date() and MySQLs DATE_FORMAT().
Please see
http://bitbybit.dk/php/date_format/
(Yes, it looks horrible. But it works)
/ Carsten
Martin Gainty skrev:
Good Afternoon All
following
que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
Date: Fri, 9 Apr 2010 19:02:33 +0200
From: cars...@bitbybit.dk
To: mgai...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: DATE_FORMAT parameter