Tag: date
-
How to convert mysql date format to own date format in 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