List:General Discussion« Previous MessageNext Message »
From:h.radners Date:March 19 1999 2:27pm
Subject:bug in CURDATE()?
View as plain text  
>Description:
	CURDATE() in string-context gives wrong year.
>How-To-Repeat:
        SELECT SYSDATE();     => 1999-03-19 14:37:58   => OK
	SELECT CURDATE()+0;   => 19990319              => OK
	SELECT CURDATE();     => 6703-03-19            => WRONG
>Originator:	Horst-W. Radners
>Organization:
  IWiS GmbH, Markgrafenstr. 11, D-10969 Berlin
  Tel.: +49 30 253769-12, Fax.: -77, e-mail: h.radners@stripped
>MySQL support: none
>Synopsis:	CURDATE() in string-context gives wrong year.
>Severity:	serious
>Priority:	medium
>Category:	mysql
>Class:		sw-bug
>Release:	mysql-3.22.20a (Source distribution)

>Environment:

System: IRIX  6.2  IP22

Some paths:  /bin/perl /bin/make /usr/local/bin/gcc /bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/mips-sgi-irix6.2/2.8.0/specs
gcc version 2.8.0
Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS='-O3'  LDFLAGS=''
Configure command: ./configure  --prefix=/usr/local/mysql
Perl: This is perl, version 5.004_03


Hi, folks!
After upgrading from mysql-3.21 CURDATE() gives a wrong yearnumber when
evaluated in string-context.
Any idea what's going wrong here?!

Thanx
___________________________________________________________________________
Horst-W. Radners
IWiS GmbH, Markgrafenstr. 11, D-10969 Berlin
Tel.: +49 30 253769-12, Fax.: -77, e-mail: h.radners@stripped
PGPkeyID 0CBD1549(RSA), 1401C833(DSS)

Thread
bug in CURDATE()?h.radners19 Mar
  • bug in CURDATE()?Michael Widenius19 Mar