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
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
