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

Reply via email to