Name: acR10002 Date: 04/17/2001



While the spec for java.sql.Date(int year, int, int) constructor doesn't
allow to create Date object if year > 9999, the spec for
java.sql.Date(long mills) still doesn't put any restrictions on the mills
value:

-------- javadoc for java.sql.Date.Date(long date) -------
public Date(long date)

     Constructs a Date object using a milliseconds time value. If the
given milliseconds value contains time information, the driver will
     set the time components to the time in the default time zone (the
time zone of the Java virtual machine running the application) that
     corresponds to zero GMT.
     Parameters:
         date - milliseconds since January 1, 1970, 00:00:00 GMT. A
negative number indicates the number of milliseconds before
         January 1, 1970, 00:00:00 GMT.
----------------------------------------------------------

Thus, if the mills value is large enough (i.e. corresponds to year>9999),
then the Date.toString() method will report wrong date. Below is an
example which demonstrate this inconsistency:

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

public class Test {

    public static void main(String argv[]) {

        java.util.Date date = new java.util.Date(10000, 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());
        long mills = date.getTime();

        Date sqlDate = new Date(mills); // create sql date given the same mills
        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
util.Date : 11900-01-01
sql.Date : 900-01-01
----------------------------------

It looks like toString() method has been reimplemented as a result of the
fix for 4413639, but the spec for java.sql.Date(long date) hasn't been
updated accordingly.

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