php mysql converting date

[sethcox]

Hello, I have mysql field set to date and a date given of 2003-06-08. I want PHP to pull that and convert it to June 8, 2003.

Is there an easy way to do this?

Thanks!

[lanjoky]

<?
$dateArray = explode("-", $date)

switch($dateArray[2]){
   case "01":
         echo "January";
         break;
   case "02":
         echo "February";
         break;
   //..... and so on 
}
echo " ".$dateArray[3].", ".$dateArray[1];

Try something like that... dont know of any easier way off hand

GL

[seby]

<? 
function datetime_to_epoch($date) { 
$break = explode(" ", $date); 
$datebreak = explode("-", $break[0]);
$time = explode(":", $break[1]);
$epoch = date("U", mktime($time[0],$time[1],$time[2],$datebreak[1],$datebreak[2],$datebreak[0])); 
$datetime = date("F jS, Y", mktime($time[0],$time[1],$time[2],$datebreak[1],$datebreak[2],$datebreak[0])); 

} 
?> 

F jS, Y formats to June 17th, 2003.

www.php.net/date

[trooper]

Easiest way to do this is to get mysql to return it in the format you want

So

SELECT DATE_FORMAT(fieldname,'%W %D %M %Y') as 'alias_name', 

This way mysql does all the hard word and you don't need any of the other stuff. By putting the alias in there it makes it easy to refer to.

HTH

GM

[dinger]

I personally do not use the MySQL date format. I simply store the date in the database as a BIGINT (using the UNIX timestamp.)

This way I can simply feed that integer to PHP's built in date() function and format it any way i want.

Chris

[trooper]

Message for dinger

Why take 2 steps to do what can be done in 1 ?

Just a small question

GM 😃

[pauliak1]

Or it can be done with this simple function:

date( " F j, Y", strtotime($date));

Hope it helps you.