incorrect datetime value sql table error 1292 1

incorrect datetime value sql table error 1292

SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session;
SET sql_mode = '';
SET GLOBAL sql_mode = '';

Here is what the above code is Doing:
1. It’s creating a database called ‘my_database’
2. It’s creating a table called ‘my_table’
3. It’s inserting a row into ‘my_table’
4. It’s selecting the row from ‘my_table’
5. It’s setting the sql_mode to ”

Similar Posts