Name: acR10002 Date: 04/17/2001



The spec for java.sql.Date(int,int,int) constructor states:
-------------------
public Date(int year,
            int month,
            int day)

     Deprecated. instead use the constructor Date(long date)

     Constructs a Date object initialized with the given year, month, and
day.

     The result is undefined if a given argument is out of bounds.
     Parameters:
         year - the year minus 1900; must be 0 - 9999
         month - 0 to 11
         day - 1 to 31
-------------------

So one will rather conclude from this spec that the valid range for "year"
parameter is 0 - 9999. However, in the real life valid range is 0-8099
(i.e. 9999 - 1900) as it is shown in the following example:

------------- Test.java ----------
import java.sql.*;

public class Test {

    public static void main(String argv[]) {

        int year = Integer.parseInt(argv[0]);
        java.util.Date date = new java.util.Date(year, 0, 1); // create util date
        java.text.SimpleDateFormat f = new // create formatter to print util date
                java.text.SimpleDateFormat("yyyy-MM-dd", java.util.Locale.US);
        f.setTimeZone(java.util.TimeZone.getDefault());

        Date sqlDate = new Date(year, 0, 1); // create sql date given the same values
        System.out.println("util.Date : " + f.format(date));
        System.out.println("sql.Date : " + sqlDate.toString());

    }
}
----------------------------------
Output:
----------------------------------
--> java -version
java version "1.4.0-beta"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.0-beta-b58)
Java HotSpot(TM) Client VM (build 1.4.0-beta-b58, mixed mode)

--> java Test 8099
util.Date : 9999-01-01
sql.Date : 9999-01-01

--> java Test 8100
util.Date : 10000-01-01
sql.Date : 000-01-01
----------------------------------
So the sql.Date.toString() method reports wrong date if year > 8099.
The same problem also exists for java.sql.Timestamp(int,int,int,int)
constructor.

======================================================================