Re: internal MYSQL clock?
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
Re: internal MYSQL clock?
Paul, Wednesday, July 17, 2002, 5:07:44 AM, you wrote: PW I just encountered a problem when entering a datetime field. Using PW 'now()' in my SQL string input a time about 13 minutes before my other PW method (a JSP System.currentTimeMillis() method - one that generates the PW time from the CPU clock) Can anyone tell me why the time generated by now() PW differed significantly to the time generated by the method above that uses PW the CPU clock?! To me, that would suggest MySQL has some kind of internal PW clock? Or am I barking up the wrong bush? PW Thanks for any input No, MySQL doesn't have internal clock. It uses environment variable TZ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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