converting datetime to PHP

intervelopment

Hey Ya'll.

In my database i have a created field with the datetime as the data type.

When i pull it out of the database it is formatted like so

2010-03-02 23:03:34

What would be the best way to display it other ways like

2nd March 2010

Cheers 🙂

rincewind456

Here is the Mysql manual page, you can format the date in any way you require.

intervelopment

Thats based on formatting it through the query though isnt it?

I want to be able to handle it through PHP

halojoy

Best way, as told many times before:

Take one mysql datetime field and
in php
1. convert it to Unix timestamp using [man]strtotime/man
2. use php [man]date[/man] to format any way from the PHP/Unix timestamp

Your Example:

<?php

$mysqltime = '2010-03-02 23:03:34';
$unixtime = strtotime($mysqltime);
$date = date('jS F Y', $unixtime);

echo $mysqltime;
echo '<br />';
echo $date; // '2nd March 2010'


///this works, too, of course in only one line.
// convert from MySQL datetime
$date2 = date('jS F Y', strtotime($mysqltime));

echo '<br />';
echo $date2;

?>

If you had search forum better for datetime
you would get 1000 of hits :rolleyes:

rincewind456

I want to be able to handle it through PHP

Why?

So rather than do

 SELECT DATE_FORMAT('dateField', '&#37;D %M %Y')

you'd rather have 10 lines of php code?

Ashley_Sheridan

I always do something like this:

$new_date = date("jS M Y", strtotime($mysql_date_string));

Look up the date() function in PHP for more information on how to format the Unix timestamp.