Timestamp gets updated with zero

Question

I need to update a column with datatype as timestamp. I run the following query:

update job_info set ProcessStartTime = UNIX_TIMESTAMP(CURDATE()) where JobID=4;

But it updates with a value : 0000-00-00 00:00:00 What could be the reason for this? Is the query incorrect?

Abhishek Sharma · Answer 1 · 2015-12-02T14:00:37.707

0

Don't use UNIX_TIMESTAMP because MySQL UNIX_TIMESTAMP() returns a Unix timestamp in seconds or your column type is datetime

update job_info set ProcessStartTime =CURDATE() where JobID=4;

or use NOW()

update job_info set ProcessStartTime =NOW() where JobID=4;

edited Dec 02 '15 at 14:00

answered Dec 02 '15 at 13:53

Abhishek Sharma

When I try to insert timestamp using curdate/now it inserts date-string. Why is that? How will I run a query that returns data for timestamp values between `1448994600` and alike? – Suhail Gupta Dec 02 '15 at 14:09
if your column type is datetime there is no issues @SuhailGupta – Abhishek Sharma Dec 02 '15 at 14:15
http://stackoverflow.com/questions/3822648/how-do-i-query-between-two-dates-using-mysql – Abhishek Sharma Dec 02 '15 at 14:16
check this link for more details @SuhailGupta – Abhishek Sharma Dec 02 '15 at 14:16

1 Answers1