Tag: sql date

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

Aug 30, 2013

—

by

darshakkumar

in sql & mysql

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