Select all AND specify Date format? Help

[Anon]

i know I can do

select * // to grab all fileds

I know I can specify the fields and include

DATE_FORMAT(dt_created, '%M %D, %Y at %l:%i %p') AS nice_date

to get the date workable...

BUT HOW do i add this date logic to a select * grab????

I ask because i don't know of any other way to format a date field in a database BESIDES in the select statement.

any help is appreciated BIG TIME

Fritz