help incorporating strtotime to get time,date

[webguync]

Hi, I have a timestamp in MySQL pulling the data out like so...

 

  echo "<td>{$row["submit_timestamp"]}</td></tr>";

 

understand I can use strtotime to get a more readable date and time. Currently looks like 2010-05-17 11:32:45

 

would rather it say, May 17, 2010 11:32:45am and if it is pm be 9:30:45pm in that format.

 

thanks in advance for any assistance.

[kenrbnsn]

Use a combination  of the strtotime and date functions.

 

Ken

[webguync]

thanks. Where would the date() and strtotime() functions need to go in the code I provided? Need a little help with the syntax.

[kenrbnsn]

<?php
echo "<td>" . date('F j, Y g:i:sa', strtotime($row["submit_timestamp"])) . "</td></tr>";
?>

 

Ken

[webguync]

great thanks!