Mysql - NOW() function calling

Posted by Ockonal on Stack Overflow See other posts from Stack Overflow or by Ockonal
Published on 2010-04-27T19:22:01Z Indexed on 2010/04/27 19:33 UTC
Read the original article Hit count: 180

Filed under:
|
|
|

Hello, I'm using php for making queries for mysql. Here is one:

UPDATE `subscribers` SET `curDate` = NOW() WHERE `e_mail` = "$resEmail"

curDate - DateTime type. The problem is that after this query curDate of given email is

0000-00-00 00:00:00

What's wrong?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about datetime