small time format problem

qadeer_ahmad

Hi,

i need to format a date as i get from database

2005-03-14 03:03:51

i need to format it like this

2005-Mar-14 03:03:51

Any short way i replace 03 to Mar or numeric month value with char month value.?

wilku

You can format the date in your sql query (I think so at least), but if not, you can do string replacing:

$search=array("-01-","-02-","-03-","-04-","-05-","-06-","-07-","-08-","-09-","-10-","-11-","-12-");
$replace=array("-Jan-","-Feb-",...);
$date = str_replace($search,$replace,$date);

Put the rest of the months instead of ...

Or you can transform the date into timestamp using [man]strtotime()[/man] and the timestamp to date again with the format you need using [man]date()[/man].

Drakla

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

Look for DATE_FORMAT

then you can do your select like

SELECT DATE_FORMAT(dateColumn, 'your format string') FROM... etc

qadeer_ahmad

Your solution is nice and working good...

Thanks a lot.