date format - mysql DATE_FORMAT using select * -


generally when make small select this

select id,date_format(updated,'%m %e, %y %l:%i %p'),title tablename; 

and give me date format like.

now have instance have select don't want specify every column because know want them all. need format dates way did in previous example.

is there way format updated column , other feilds , still keep there order ?

i tried this

select *,date_format(updated,'%m %e, %y %l:%i %p') updated tablename 

but doesn't seem doing anyhting

i did not tested try this

select t.*,date_format(updated,'%m %e, %y %l:%i %p') updated tablename t; 

Comments

Popular posts from this blog

php - What is the difference between $_SERVER['PATH_INFO'] and $_SERVER['ORIG_PATH_INFO']? -

fortran - Function return type mismatch -

queue - mq_receive: message too long -