[RESOLVED] Date format

[Shamrox]

I'm using the below to extract date info from a TIMESTAMP type field and it returns blank for the datecreated field.
Is this not the proper format to use with the timestamp? I'm looking to just get the month/day/year from the timestamp.

SELECT qid, jobno, DATE_FORMAT(datecreated, '%c/%e/%Y') FROM moms_query ORDER BY datecreated ASC

[rikmoncur]

SELECT DATE_FORMAT( datecreated,'%c %e %Y') AS datecreated, qid, jobno
FROM moms_query
ORDER BY datecreated ASC

[Shamrox]

Ah yes, I forgot that little piece.

Thanks much.