Hi All, I have a date format of -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
strftime()
offers a lot of formatting options for dates.
Hope it helps.
RUBANOWICZ Lisa wrote:
Hi All, I have a date format of -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
]
Subject: Re: [PHP-DB] Date format in
MySQL
02/03/2003
09:32 AM
$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