CODEWITHSUNDEEP
mysql
J Brun
J Brun

Reputation: 1284

Datetime in MySQL

I'm an experience MS-SQL programmer, but new to MySQL.

I create a table:

create table temp 
(
    Col1 DateTime NOT NULL
)

I try to insert into the table:

insert into temp select '1/1/2014';

I get an error "Incorrect datetime value". Last I check, that was a valid date.

Upvotes: 0

Views: 53

Answers (1)

jpcanamaque
jpcanamaque

Reputation: 1069

Your date format is not valid when inserted in MySQL. The correct way is to insert it in 'YYYY-MM-DD' or 'YY-MM-DD'

Please see http://dev.mysql.com/doc/refman/5.6/en/date-and-time-literals.html

Upvotes: 1

Related Questions