How do you reformat system date in MySQL?Explain various formats ..? how to add a date/hour/minute/second to a date?

Showing Answers 1 - 1 of 1 Answers

rockxy1214
Profile Answers by rockxy1214

Feb 20th, 2008

you can change the date time format with DATE_FORMAT() function

eaxmple:

select date_format(datetime column,'%Y-%M-%d %H:%i:%s') from table_name;

or u can add some time to date with this

select concat('+strDate_End+',' 13:30:00.0') from table_name