TIMESTAMP format returns a day in advance.

[chris burgess]

>Description:

	Any calculation using TIMESTAMP format returns a date one day in
	advance of the expected result.

	I can reproduce this on one machine only. It appears machine
	specific, because tests on several others have failed to produce the
	same unexpected results. Other software appears able to calculate
	dates reliably.

	System date and time have been verified, and I'm a first-time
	mysqlbug user, so please be gentle ;)

	I'm not subscribed to the mysql-list; please CC replies to
	chris@stripped.

>How-To-Repeat:

	mysql> select from_unixtime(unix_timestamp('1999-10-01 13:00:00'));
	+------------------------------------------------------+
	| from_unixtime(unix_timestamp('1999-10-01 13:00:00')) |
	+------------------------------------------------------+
	| 1999-10-02 13:00:00                                  |
	+------------------------------------------------------+
	1 row in set (0.00 sec)

>Fix:

	None known.

>Submitter-Id:	<submitter ID>
>Originator:	chris burgess
>Organization:  ibex ltd
  
>
>MySQL support: [none]
>Synopsis:	TIMESTAMP calcs return unexpected results
>Severity:	
>Priority:	
>Category:	mysql
>Class:		
>Release:	mysql-3.22.25 (Source distribution)
>Server: /usr/bin/mysqladmin  Ver 7.11 Distrib 3.22.25, for pc-linux-gnu on i586
TCX Datakonsult AB, by Monty

Server version		3.22.25-log
Protocol version	10
Connection		athena via TCP/IP
TCP port		3306
Uptime:			1 day 22 hours 27 min 59 sec

Threads: 3  Questions: 7355  Slow queries: 0  Opens: 59  Flush tables: 1  Open tables: 20
>Environment:
	
System: Linux athena 2.2.10 #3 Tue Jul 6 21:28:37 NZST 1999 i586 unknown
Architecture: i586

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs
gcc version 2.95.2 19990906 (prerelease)
Compilation info: CC='gcc'  CFLAGS='-O2 -fomit-frame-pointer'  CXX='c++'  CXXFLAGS='-O2
-fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
Configure command: ./configure  --enable-shared --enable-assembler
--with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock
--prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/mysql
--datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info
--includedir=/usr/include --mandir=/usr/man
Perl: This is perl, version 5.005_03 built for i386-linux