MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Insert into clause problem with date type
Posted by: kilin wang
Date: July 03, 2008 03:07AM

Hi Jens,

first, you should quota the values of DATE type. such as INSERT INTO postraids (datep) values ('2008/06/28')

second, the value of DATE type field should be of YYYYMMDD or YYMMDD format. i mean it shall be 6 or 8 digital number.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Insert into clause problem with date type
4959
jens simonsen
July 01, 2008 11:52AM
Re: Insert into clause problem with date type
2223
kilin wang
July 03, 2008 03:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.