hi, which date does mysql use to calculate CURDATE()? I have a master database telling me via the select CURDATE(); command that today is :
mysql> select CURDATE(); +------------+ | CURDATE() | +------------+ | 2002-12-01 | +------------+ 1 row in set (0.00 sec) even though the linux date is set correctly to the 2nd dec [root@db01 ntp-4.1.1]# date Mon Dec 2 13:20:15 EST 2002 [root@db01 ntp-4.1.1]# cheers Kath --------------------------------------------------------------------- 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