>Description:
This problem is being experienced on both MySQL 4.0.0 and 4.0.1.
Currently the system's timezone is set to PST, and MySQL's timezone variable
is PST (no problem there)
However if I do a NOW() on the system, the returned result is 8 hours earlier
that the current time
Any helpful hints or suggestions would be much appreciated
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
>MySQL support: none
>Synopsis: NOW returning incorrect results
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.1-alpha (Source distribution)
>Server: /bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.1-alpha-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 8 min 24 sec
Threads: 4 Questions: 28 Slow queries: 0 Opens: 11 Flush tables: 1 Open tables: 4
Queries per second avg: 0.056
>Environment:
System: Linux master-db 2.4.14 #1 SMP Thu Nov 8 18:26:59 /etc/localtime 2001 i686
unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Nov 7 18:27 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 1013224 Mar 21 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20266642 Mar 20 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Mar 20 2000 /usr/lib/libc.so
lrwxrwxrwx 1 root root 29 Nov 7 18:27 /usr/lib/libc.so.1 ->
/usr/i486-sysv4/lib/libc.so.1
Configure command: ./configure --without-docs --without-bench --without-debug
--prefix=/var/lib/mysql --with-mysqld-user=mysql
---------------------------------------------------------------------
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
