List:General Discussion« Previous MessageNext Message »
From:aldrian Date:April 23 1999 11:00am
Subject: Week in year before 1998 starts from 1 instead of 0
View as plain text  
>Description:
	Bug in WEEK command??
>How-To-Repeat:

mysql> select week('1997-01-01');
+--------------------+
| week('1997-01-01') |
+--------------------+
|                  1 |
+--------------------+
1 row in set (0.00 sec)

mysql> select week('1997-12-31');     
+--------------------+
| week('1997-12-31') |
+--------------------+
|                 53 |
+--------------------+
1 row in set (0.00 sec)

mysql> select week('1998-01-01'); 
+--------------------+
| week('1998-01-01') |
+--------------------+
|                  0 |
+--------------------+
1 row in set (0.01 sec)

mysql> select week('1998-12-31');     
+--------------------+
| week('1998-12-31') |
+--------------------+
|                 52 |
+--------------------+
1 row in set (0.01 sec)

>Fix:
	Need to know

>Submitter-Id:	<submitter ID>
>Originator:	
>Organization:
  ========================================================================
  Aldrian Gintingsuka -- Systems Consultant -- Mitra Integrasi Informatika
  Phone: +62-21-251-1360 ext. 1414 -- Fax: +62-21-251-2748
  Email: aldrian@stripped, aldrian@stripped
  ------------------------------------------------------------------------
  Si tu es contre Dieu, tu es contre l'homme (Enigma: Sadeness part I)
  
>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:	Week in year before 1998 starts from 1 instead of 0
>Severity:	
>Priority:	
>Category:	mysql
>Class:		
>Release:	mysql-3.22.21 (Source distribution)

>Environment:
	
System: SunOS vdtelco 5.6 Generic_105181-08 sun4m sparc SUNW,SPARCstation-4
Architecture: sun4

Some paths:  /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/local/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release)
Compilation info: CC='gcc'  CFLAGS='-O6 -fomit-frame-pointer'  CXX='gcc'  CXXFLAGS='-O6
-fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti
-DDONT_USE_DEFAULT_FIELDS'  LDFLAGS=''
Configure command: configure  --without-docs --without-bench --without-debug
--enable-thread-safe-client --with-low-memory --with-mysqld-user=mysql98
Perl: This is perl, version 5.005_03 built for sun4-solaris-thread
Thread
Week in year before 1998 starts from 1 instead of 0aldrian23 Apr
  • Week in year before 1998 starts from 1 instead of 0Michael Widenius26 Apr
    • Re: Week in year before 1998 starts from 1 instead of 0Aldrian Gintingsuka26 Apr
      • Re: Week in year before 1998 starts from 1 instead of 0Michael Widenius27 Apr
        • Re: Week in year before 1998 starts from 1 instead of 0Aldrian Gintingsuka27 Apr
          • Re: Week in year before 1998 starts from 1 instead of 0Michael Widenius27 Apr