List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 11 1999 5:03am
Subject:Re: NOW()
View as plain text  
On Mi, 1999-08-11 04:57:23 -0400, Dave Paradox wrote:
> Does NOW() get UTC or local time?

MySQL manual chapter "18.12 Timezone problems" says:
| If you have a problem with SELECT NOW() returning values in GMT and
| not your local time, you have to set the TZ environment variable to
| your current timezone. This should be done for the environment in
| which the server runs, for example in safe_mysqld or mysql.server.

This suggests that time functions in MySQL normally should give you
local time.

Martin Ramsch <m.ramsch@stripped> <URL: >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
NOW()Paradox11 Aug
  • Re: NOW()Martin Ramsch11 Aug