RE: What does NOW() return: linux time or something else?

2007-03-22 Thread Jerry Schwartz
NOW() returns the current time, as known by the Linux server, in the time_zone set for the connection. By default, this seems to be "system", meaning whatever time zone the server picked up from the system at the time it was started. In Linux, this would be the environment variable TZ. If you chang

RE: What does NOW() return: linux time or something else?

2007-03-21 Thread Tim Lucia
> -Original Message- > From: murthy gandikota [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 21, 2007 6:05 PM > To: mysql@lists.mysql.com > Subject: What does NOW() return: linux time or something else? > > Hi > I tried to look up the time functions specifically for the disparity >