MySQL doesn't have an internal clock. It uses the O/S's clock.
Each of our servers (both Linux and Win32) running MySQL logs into a time
server to set the system clock twice a day. Time references in the MySQL
databases are always dead-on.
----- Original Message -----
From: "Paul Wallace" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 9:07 PM
Subject: internal MYSQL clock?
Hi,
I just encountered a problem when entering a datetime field. Using
'now()' in my SQL string input a time about 13 minutes before my other
method (a JSP System.currentTimeMillis() method - one that generates the
time from the CPU clock) Can anyone tell me why the time generated by now()
differed significantly to the time generated by the method above that uses
the CPU clock?! To me, that would suggest MySQL has some kind of internal
clock? Or am I barking up the wrong bush?
Thanks for any input
P.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
