Re: Date format in MySQL

$query = mysql_query("SELECT UNIX_TIMESTAMP(fieldname) AS date WHERE id = '1';"); $array = mysql_fetch_array($query); $mydate = date("j F, Y",$array[date]); Change fieldname and the where clause, and that should work. If you want to further munipulate how it looks, just look at the date manual page: http://www.php.net/date And change the first parameter to the date function. On Mon, 2003-02-03 at 09:09, RUBANOWICZ Lisa wrote: Hi All, I have a date format of YYYY-MM-DD in MySQL and am showing it on a PHP page. However I want to show it as "2 February, 2003" or "2 February" Can someone please help me. The date will not necessarily be todays date (I looked at the datetime() function and the getdate() function but couldn't work it out for these) Thanks for your support All the best Lisa Lisa Rubanowicz CNH Ireland Tel: +353 46 77663 Email: <mailto:lisa.rubanowicz@cnh.com> lisa.rubanowicz@cnh.com -- Adam Voigt (adam@cryptocomm.com) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc

Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc