Re: Date format in MySQL

[Adam Voigt <adam@cryptocomm.com>]

$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: signature.asc
Description: This is a digitally signed message part