Print Full DATETIME from mysql database

deanbayley

I need to print the full date from a MySQL database, it is stored as:

DATETIME

2003-05-01 19:30:00

i need to print it as:

1st May 2003 7:30 PM

Any help would really be apreciated!!

jabba_29

Check out the manual

and see the user examples towards the bottom of the page :p

deanbayley

I have looked at the manual and what you have suggested isn't quite what i was looking for, i need to print the date FROM a MySQL database, not just print the current date.

Thanks.
Dean.

The_Chancer

The answer is there - look at using something along the lines of:

date("how you want it", strtotime("MYSQLDATE"))

The manual does have the answers...

xblue

you can as well do it right within your query. Scroll down to DATE_FORMAT
http://www.mysql.com/doc/en/Date_and_time_functions.html