How to convert MS SQL DateTime into Java Date?

Hi
I am not able to figure how to conevert a MS SQL 2000 DateTime to Java format viz. date, time or Time stamp?
I am trying to retrive from database using resultset
I tired string, object etc
any help will be appreciated
Thanks
Ravi

I'm sure there's a better solution than this, but in your query, you could select YEAR(theDate), MONTH(theDate) and DAY(theDate). Then, construct a java date from these values.

ResultSet.getDate(index) should return a java.sql.Date. Dint this work for you?
reg.
[ December 02, 2003: Message edited by: shankar vembu ]

Thanks Marie
That one works cool. Is there a way to extract the time similarly?
Ravi