Truncate time part from date [ ORACLE TRUNC equivalent in MySQL ]

In Oracle TRUNC(data_time_var) returns only the date portion of a date_time data type.

In MySQL to truncate time part from date we have to use

SELECT DATE_FORMAT(date_time_var, '%Y-%m-%d')
Try different date formate.

Further date time function in mysql can be found in
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

|