Formating a variable that holds a timestamp

[86Stang]

I used the timestamp type to capture the date/time of when a record was created.  I would like to display that timestamp but in a different format.  In the database it displays as 2008-01-25 03:14:47 but I'd like to display it as January 25, 2008.  Anybody got a clue on how to do this?

[revraz]

Search the forums for strtotime

[sasa]

try

<?php
$a = '2008-01-21 03:14:47';
echo $t = date('F d<\sup>S</\sup>, Y.', strtotime($a));
?>

[haku]

Its good practice to always store dates in your database as unix timestamps, and to convert them when they come out. Unix timestamps can be formatted pretty much anyway you want, so they are very versatile. Check out date(): http://jp2.php.net/date to find out more.

 

If you need to convert a date into a unix timestamp when you put it in your database, you can use mktime(): http://jp2.php.net/mktime

[harristweed]

You can use inbuilt mysql functions to extract timestamp dates in different formats:

 

select  date_format('your field name', ' %M %e, %Y')  AS readable_date........WHERE....

 

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html