• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Passing java.sql.date to constructors

 
Adrienne Peck
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 2409
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1467
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
got hru this link http://www.javaworld.com/jw-12-2000/jw-1229-dates.html
 
Edwin Dalorzo
Ranch Hand
Posts: 961
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This works for me:



I hope it helps!
 
Adrienne Peck
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks!
 
Paul Clapham
Sheriff
Posts: 21114
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic