do I need to insert am/pm in the database?

[abs0lut]

I need to show if the date is am/pm, do I need to insert am/pm in the database? the data type is datetime

could you please help me?

 

[kenrbnsn]

No, a datetime value has the time stored as a 24 hour clock.  You would used a combination of the date() and strtotime() functions:

 

<?php
$datestr = '2008-08-08 18:48:39'; // assume this was just pulled from the database
echo date('g:i A',strtotime($datestr));
?>

 

Ken

[Gighalen]

Or you could use a timestamp - just be sure to include the A (Capital A, like in kens example above) in your date format, like so:

 

<?php
$time = time();
$date = date('D, M j, Y, g:i A', $time);
?>

[abs0lut]

thank you very much