change data time format

[kenny873]

when I retrieve my date and time from database and display as follow:

2003-03-14 14:42:18

How can I easily change the format into :

Mar 14th, 2003, 2:42pm

[ahundiak]

The basis idea is to use the substr function and the mktime function to convert it into a timestamp. You can then use the date function to get whatever format you want.

Here is an example that converts a string in YYYYMMDD format. You should be able to modify it to suit your needs.

function format_date($date)
{    

  $timestamp = mktime(0,0,0,
    substr($date,4,2),
    substr($date,6,2),
    substr($date,0,4));

  $date_str = date('D M d',$timestamp);
  return $date_str;
}

[rohithmr]

well, the best method i think, is to make mySQl do teh work of converting it, change the SQL query to

$sql = "SELECT DATE_FORMAT(date,%b %D, %Y, %h:%i%p) as formatted_date from tabel_name";

Please note that if ur selecting other columns on teh same query, then u can leave everything untouched and jus change the 'date' column to DATE_FORMAT(date,%b %D, %Y, %h:%i%p)