MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: C mysql-insert in DATE and TIME field
Posted by: Phillip Ward
Date: December 08, 2014 06:59AM

Date and Time literals, like strings, have to wrapped in single quotes: 

INSERT INTO dht22_test.temp_humid VALUES ( NULL, 18.9, 45.4, 19.50, '2014-12-08', '01:28:11' )

or better still, if your application language supports them, use Parameterised Queries to handle this for you.

Regards, Phill W.

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


Subject
Written By
Posted
C mysql-insert in DATE and TIME field
achim altmann
December 08, 2014 03:27AM
Re: C mysql-insert in DATE and TIME field
achim altmann
December 08, 2014 03:55AM
Re: C mysql-insert in DATE and TIME field
Phillip Ward
December 08, 2014 06:59AM
Re: C mysql-insert in DATE and TIME field
achim altmann
December 08, 2014 08:20AM
Re: C mysql-insert in DATE and TIME field
Phillip Ward
December 09, 2014 06:55AM
Re: C mysql-insert in DATE and TIME field
achim altmann
December 09, 2014 09:49AM
Re: C mysql-insert in DATE and TIME field
Rick James
December 09, 2014 03:39PM


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.