[UPHPU] MySQL NOW() doesn't know minutes

[thebigdog]

Wade Preston Shearer wrote:
> I am using NOW() in an MySQL update statement. It gets the date and hour 
> correct but sets the minute to ":02" no matter when it is run. Any ideas?

i would think that there is an issue with the data type that you used to store 
the datetime from the now() function. Can you let us know what that data type is 
that you are using and the mysql version of the database. I tested it out with 
the following code and it worked fine for me:

create table test (
   test_datetime datetime not null;
)

insert into test values (now());

update test set test_datetime = now(); select * from test;


it worked fine for me and i am on version 5.0.67. there are some setting in 
mysql that can modify what now() returns. that might be something too look at as 
well.


-- 
thebigdog