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
Joined: Oct 01, 2002
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.
Joined: May 10, 2001
ResultSet.getDate(index) should return a java.sql.Date. Dint this work for you? reg. [ December 02, 2003: Message edited by: shankar vembu ]
Joined: Feb 26, 2002
Thanks Marie That one works cool. Is there a way to extract the time similarly? Ravi