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
Post a Comment