MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: need help insert date into datetime column
Posted by: Jonathan Stephens
Date: August 03, 2015 03:39AM

DATE format is YYYY-MM-DD, so 15 September 2012 -> 2012-09-15. You're apparently trying to insert it as 'YYYY-DD-MM'.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle

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


Subject
Written By
Posted
need help insert date into datetime column
Paul Smith
August 02, 2015 01:46AM
Re: need help insert date into datetime column
Paul Smith
August 02, 2015 02:34AM
Re: need help insert date into datetime column
Peter Brawley
August 02, 2015 09:39AM
Re: need help insert date into datetime column
Rick James
August 02, 2015 03:37PM
Re: need help insert date into datetime column
Peter Brawley
August 03, 2015 09:52AM
Re: need help insert date into datetime column
Jonathan Stephens
August 03, 2015 03:39AM


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.