###covert into the date format set sql_safe_updates =0; update new_data set order_date=date_format(str_to_date(order_date,'%m/%d/%Y'),'%Y-%m-%d'); ###now fn SELECT ...