Want to match two date columns of two tables both have diff formats in mysql One column format is like '2005-03-22' and other is like '2005-03-22  22:09:01'.. i tried to_date function but its not working in mysql..which function should i use?
Found it... it will be date_format(date , '%Y- %m- %d')