Matthew1980 - 10:07 am on Sep 3, 2010 (gmt 0)

Hi there Impact,

[dev.mysql.com ]

Check the information out from that link, then you can use (for retrieval from DB):-

SELECT DATE_FORMAT('THE_COLUMN_NAME', %M %d %Y) AS `formatted date`

in the sql you are using. All you will need to do is experiment with the different formats until you are happy with what you see. This will just take the date in the column and re-order it into the format as you have specified and then store that into the temp var using the AS instruction.

Hopefully I have understood you correctly, and hopefully makes sense too ;)

Cheers,
MRb