t; CC: mysql@lists.mysql.com
> Subject: Re: DATE_FORMAT parameter question
>
> 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/dat
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 t
> 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
Basicay, your date_format works like:
select DATE_FORMAT('YY-MM-DD','%y-%b-%d') from DUAL;
"Martin Gainty" escreveu na mensagem
news:blu142-w2137936b18ae273dbd6cb1ae...@phx.gbl...
Good Afternoon All
following the documentation available at
http://dev.mysql.com/doc/refman/5.1/en/date-and-tim
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;
+-
