Date conversion in MySQL

With recent release, MySQL throws error when inserting dates. This is because, by default "strict mode" is enabled. To get rid of the errors, we need to do something as follows:

SHOW VARIABLES LIKE 'sql_mode';

set sql_mode='';