date_format from mysql, where am i messing up?

[bliss322]

i'm trying to pull a date out of mysql (it's formatted 2002-12-31) and, using date_format, reformat it to look like 12/31/02...

i looked up date_format on the mysql website, thought i followed the reference well, but now it those two variables are empty after the sql pull.

help?

code sample:

SELECT adID,adAuthor,adTitle,adContent, date_format(adStartDate, '%m/%d/%y') ,date_format(adEndDate, '%m/%d/%y') FROM tbl_classifieds WHERE adID = $editID");

[statrat]

try using single quotes around 'adStartDate' and 'adEndDate'.

[bliss322]

i got it, thanks.

to make it work, i had to do:

date_format(adStartDate, '%c/%e/%y') as adStartDate

[hand]

$query = "SELECT adID,adAuthor,adTitle,adContent, date_format(adStartDate, '%m/%d/%y') AS adStartDate,date_format(adEndDate, '%m/%d/%y') AS adEndDate FROM tbl_classifieds WHERE adID = $editID";

[hand]

I see, I was a little bit too late :p