List:General Discussion« Previous MessageNext Message »
From:Jay Ess Date:May 10 2010 12:55pm
Subject:Re: Out of range value for column 'datestamp' at row 1
View as plain text  
On 2010-05-09 13:29, Prabhat Kumar wrote:
> INSERT INTO myTable_info (id,range, total_qt, qt_correct, finish_time,
> username, datestamp) VALUES (NULL,'Kumar', '20', '17', '111', 'Prabhat','*
> NOW()');*
>
> Last_SQL_Error: Error 'You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right syntax
>
> I think problem with* `datestamp` datetime NOT NULL default '0000-00-00
> 00:00:00',*
>
> Can any one please suggest me, how to deal with this error.
>

Remove the ' around NOW(). ' Makes NOW() a literal string and not a function call.

Thread
Out of range value for column 'datestamp' at row 1Prabhat Kumar9 May
  • Re: Out of range value for column 'datestamp' at row 1Carsten Pedersen9 May
  • Re: Out of range value for column 'datestamp' at row 1Jay Ess10 May
    • Re: Out of range value for column 'datestamp' at row 1Prabhat Kumar10 May