Passing java.sql.date to constructors

[Adrienne Peck]

Hi,

I'm writing a program where I need to pass the java.sql.date in the constructor. When I started to test this code, it would not compile because of the format of the date. This is the format that I used:

January 1, 2000 01:01:01.001

The compiler does not like this format. I tried taking out spaces and that didn't work. I shouldn't take out the other symbols, should I? What format should the java.sql.date be in when passed to a constructor.

Thanks!

[Keith Lynn]

According to the API docs for 1.5, there is only one constructor of java.sql.Data (that is recommended. There is one that is deprecated). It accepts a long.

[Adrienne Peck]

I tried to put that date in as a long. However, eclispe states that the number should be an integer. So, I can put in the CCYYMMDDHH just fine. Not able to put in minutes and seconds.

How can the java.sql.Date object be an integer? Does this mean that something else needs to happen once that value is passed in?

I was thinking of doing the following with the date that is passed in:

new java.sql.Date(new GregorianCalendar().getTimeInMillis());

Would this get the MMDDSS time that we need from java.sql.Date object?

[kri shan]

got hru this link http://www.javaworld.com/jw-12-2000/jw-1229-dates.html

[Edwin Dalorzo]

This works for me:

String strDate = "January 1, 2000 01:01:01.001";
DateFormat formatter = new SimpleDateFormat("MMMMM d, yyyy hh:mm:ss.SSS");

java.util.Date date = formatter.parse(strDate);
java.sql.Date sqlDate = new java.sql.Date(date.getTime());

System.out.println(sqlDate);

I hope it helps!

[Adrienne Peck]

Thanks!

[Paul Clapham]

It would be even simpler to omit the "01:01:01.001" part, since java.sql.Date models only a date with no time component.