How to convert mysql date format to own date format in MYSQL?

—

by

SELECT sum(rate),DATE_FORMAT(date_time, ‘%Y-%c-%d’) as dt FROM `trans_tble` group by `dt`

Reff link : http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format

date date format mysql date format mysql date.mysql sql sql date sql date format

Comments

Leave a Reply Cancel reply