Error : datetime column Incorrect datetime value: ''

Question

I have datetime column(test_date) with default value set to current_timestamp

but when Update the table it shows

Error in Updation Query
Incorrect datetime value: '' for column 'test_date' at row 1

I even changed the column type to timestamp but still it throws the same error

Error in Insertion Query insert into tbl_testimonials(test_title,test_image,test_content,test_date,status) values('hi','','this is checking','', 'Y') Incorrect datetime value: '' for column 'test_date' at row 1

My question is different : the question in MySQL CURRENT_TIMESTAMP on create and on update discuss about having to timestamp values in the same table and the error is

ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

But I have a single column with timestamp value and my error is

Incorrect datetime value: '' for column 'test_date' at row 1

So I think my question is different

Please help

@Milan Gupta bro I have updated my question with the query bro with new value — scriptkiddie, Oct 13 '16 at 06:31
@S.I bro read my question please, I have already set the default value to current_timestamp in phpmyadmin.... — scriptkiddie, Oct 13 '16 at 06:33
@S.I. I am not inserting anything bro, I just want my mysql server to assign the current_timestamp if it's empty — scriptkiddie, Oct 13 '16 at 06:34
@scriptkiddie If you want mysql to do it for you then don't include test_date in your key values. So it should go something like `tbl_testimonials(test_title,test_image,test_content,status) values('hi','','this is checking', 'Y')` — Milan Gupta, Oct 13 '16 at 06:36
@Milan Gupta Thank you bro it worked. If you post it as an answer I will mark it as an answer and upvote it.. — scriptkiddie, Oct 13 '16 at 06:50

score 2 · Accepted Answer · answered Oct 13 '16 at 06:53

2

If you want mysql to do it for you then don't include test_date in your key values. So it should go something like below:

tbl_testimonials  
(test_title,test_image,test_content,status) values  
('hi','','this is checking', 'Y')

answered Oct 13 '16 at 06:53

Milan Gupta

1,181
8
21

Error : datetime column Incorrect datetime value: ''

1 Answers1