Error while inserting date - Incorrect date value

Question

I have a column called today and the type is DATE   When I try to add the date in the format  07-25-2012  I get the following error      Unable to run query Incorrect date value   07-25-2012  for column

User · Answer

You need to convert the date to YYYY-MM-DD in order to insert it as a MySQL date using the default configuration.

One way to do that is STR_TO_DATE():

insert into your_table (...)
values (...,str_to_date('07-25-2012','%m-%d-%Y'),...);

User · Answer

You can use  DATE  as a data type while you are creating the table  In this way  you can avoid the above error  Eg   CREATE TABLE Employee  birth date DATE   INSERT INTO Employee VALUES  1967-11-17

User · Answer

Generally mysql uses this date format  Y-m-d H i s

User · Answer

I had a different cause for this error  I tried to insert a date without using quotes and received a strange error telling me I had tried to insert a date from 2003     Although I was already using the YYYY-MM-DD format  I forgot to add quotes around the date  Even though it is a date and not a string  quotes are still required

User · Answer

you need to use YYYY-MM-DD format to insert date in mysql

User · Answer

As MySql accepts the date in y-m-d format in date type column  you need to STR TO DATE function to convert the date into yyyy-mm-dd format for insertion in following way   INSERT INTO table name today   VALUES STR TO DATE  07-25-2012    m- d- y         Similary  if you want to select the date in different format other than Mysql format  you should try DATE FORMAT function  SELECT DATE FORMAT today    m- d- y   from table name

User · Answer

This is the date format       The DATE type is used for values with a date part but no time part    MySQL retrieves and displays DATE values in  YYYY-MM-DD  format  The   supported range is  1000-01-01  to  9999-12-31     Why do you insert  07-25-2012  format when MySQL format is  2012-07-25    Actually you get this error if the sql mode is traditional strict mode else it just enters 0000-00-00 and gives a warning  1265 - Data truncated for column  col1  at row 1

[mysql] Error while inserting date - Incorrect date value:

Examples related to mysql

Examples related to sql