[Resolved] formatting data from a DATETIME field

[sneakyimp]

i have a db with timestamps of type DATETIME. generally records in this table insert the mysql function NOW() into this field.

what i get is data like YYYY-MM-DD HH-MM-SS

Is there some quick easy way to get "January 4, 2005 at 11:30pm" out of this without string parsing and switch statements?

[AstroTeg]

Look into MySQL's date_format() function. You can format the string from within SQL which goes pretty fast.

[sneakyimp]

sweet.

indeed, the function works...docs found here:

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

SELECT date_format(date_stamp, '%M %e, %Y) as my_date FROM table_x