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? ...
I'm trying to update a database field to the current time, but can't pass "now()". I get the following error: 'now' is not a recognized built-in function name. The method I'm using to query the database is as follows: Public Sub main() Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Set cnn = New ADODB.Connectio...
I just tried to insert two rows with the current datetime and then calculated the elapsed time since that date. Here are the rows from my table after two insertions and using NOW() function to set the timestamp: mysql> select * from pendingActivations; +--------+------------+---------------------+ | userId | code | timestamp ...