Re: system date / curdate()

2002-12-02 Thread DL Neil
Hi Kath, Are the MySQL machine, the Linux machine, and the client you are using all the same machine? Which timezone is Linux set to? Which timezone is your local/client machine in, and/or set to? Please advise, =dn > hi, which date does mysql use to calculate CURDATE()? I have a master > databas

system date / curdate()

2002-12-01 Thread Kath O'Donnell
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