|
Posted by Lou on 10/06/06 18:35
On 6 Oct 2006 07:10:12 -0700, Pankaj wrote...
>
>I have fetched date from mysql database which I get in yyyy-mm-dd
>format. I am able to change this to dd-mm-yyyy (eg 06-12-2006). How can
>I display this in dd-mmm-yyyy format (6th Dec 2006)
>
>Thanks
>
The following link from the MySQL reference manual would show how to format the
date with your SQL query. Might be easier doing that then getting the date with
SQL then trying to format it with PHP...
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
Lou
--
Newsguy Express 30 GB / month $9.95
http://www.newsguy.com/overview.htm
Navigation:
[Reply to this message]
|