The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

No, there's no column in the table, that's why I wrote "first column in the select list"

You need the PrintDate "calculated" field because you want the formatted date to print out
The column you don't need to select in the query is ShowDate (unless used for some purpose in your script/program)

OK, when you get the result from the DB, the field called PrintDate (the alias for the result from the date_format() function) contains the formatted value of ShowDate, while ShowDate is the unformatted value (and I don't know if you really need this one in the sql above).