Help formatting a date from MySQL

I am using the following in a MySQL query to return a date,

DATE_FORMAT(DateTime,'%M %D, %Y, %T') as DateTime

What I would like is the date returned with an "at" between the year and time. (e.g September 9th, 2001 at 13:33:12)

I can't do it by putting the "at" inside the backets so how is it done?

Um, actually, Ben, you can put the "at" inside the brackets. Try pasting the following into MySQL and you'll see what I mean:

SELECT DATE_FORMAT(NOW(),'%M %D, %Y at %T');

It works perfectly.

When I do this the "a" in "at" gets replaced by the three letter representation of weekday.

So I get the following displayed,

September 7th, 2001 Frit 00:02:36

Is there a way of telling MySQL not to replace the "a" but to just display it?

Ben

That's truly bizarre, as it doesn't do that in my version of MySQL.Have you tried escaping it?

SELECT DATE_FORMAT(NOW(),'%M %D, %Y \at %T');