Using MySQL DATETIME Help!

ecreative

I am currently using the datetime function for a database and when displaying the records i want to change the time format as its displayed for example '2006-04-23 21:05:23' is the way its stored but i want to display it as '24th April 2006 21:05' is there a script or tutorial i can use?

Oni

I'm not sure about Mysql but you could try the php date function to give the date practically any format you want?

http://tr.php.net/manual/en/function.date.php

Houdini

//to convert a time for MySQL 
$myinput='12/15/2005';
$sqldate=date('Y-m-d',strtotime($myinput));
echo $sqldate."<br />";
//Monday April 10,2006 your example date
$testdate="2006/4/10"; //From MySQL to your $mydate
$mydate = date('l F j, Y',strtotime($testdate));
echo $mydate;

Weedpacket

On the other hand, MySQL has a DATE_FORMAT function of its own. Funnily enough, there is information about in the MySQL manual (exactly where you'd expect to find information about how to use MySQL).

ecreative

thanks Houdini thats exactly what I needed!