Displaying DATE or DATETIME in PHP

[Colleen Robledo, MLIS]

Hello,

I'm still pretty new to PHP and MySQL, and have a PHP scripting
question.

If I'm querying DATE info from a MySQL database, and displaying it
with PHP echo statements... is there a PHP script I can use to convert
the DATE data to standard calendar format?

Example:

2007-10-12 displayed as October 12, 2007

Thank you,

Colleen Robledo

[Rik Wasmus]

On Tue, 16 Oct 2007 09:42:28 +0200, Colleen Robledo, MLIS
<co************ @gmail.comwrote :

Hello,

I'm still pretty new to PHP and MySQL, and have a PHP scripting
question.

If I'm querying DATE info from a MySQL database, and displaying it
with PHP echo statements... is there a PHP script I can use to convert
the DATE data to standard calendar format?

Example:

2007-10-12 displayed as October 12, 2007

You are better of using the DATE_FORMAT(dat e_field, '%M %e, %Y') function
in MySQL, as it knows for sure what date it is:
http://dev.mysql.com/doc/refman/5.0/...on_date-format

However, would you wish to do it in PHP, look at these:
http://www.php.net/strtotime
http://www.php.net/date
http://www.php.net/strftime
--
Rik Wasmus

[Krustov]

<comp.lang.ph p>
<Colleen Robledo, MLIS>
<Tue, 16 Oct 2007 07:42:28 -0000>
<11************ *********@e9g20 00prf.googlegro ups.com>

I'm still pretty new to PHP and MySQL, and have a PHP scripting
question.

If I'm querying DATE info from a MySQL database, and displaying it
with PHP echo statements... is there a PHP script I can use to convert
the DATE data to standard calendar format?

Example:

2007-10-12 displayed as October 12, 2007

<?php

$lager="2007-10-12";

$beer=explode('-',$lager);

$drink=date("F-d-Y",mktime(0,0,0 ,$beer[1],$beer[2],$beer[0]));

print "The converted date is $drink <br>";

?>
--
www.vhit.co.uk
www.jpgimage.co.uk
www.phpwhois.co.uk
www.cannabiswindow.co.uk