Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

About convert datetype 'DATETIME' From SQL (access 2000)into JAVA

 
Tracy Lee
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

when I tried to convert the data in a MS Access Database, which I create in Access 2000, all number and string worked fine. But there is a table containning a date type --- 'Date/time' with short date form e.g. today 01-05-08(yy-mm-dd). when compiling it, shows 'DATATIME' type. Java.sql.resultSet has got no method to convert it ( relevant are getDate, getTime, getTimeStamp).
Could anybody Help. I would appropriate it.
 
Sergei Voropay
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just use getDate() on the ResultSet, you'll be fine.
 
Tracy Lee
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I had tried before and I tried it again, Unfortunately, it doesn't work.
Thank you anyway.
 
Jim Yingst
Wanderer
Sheriff
Posts: 18671
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Apparently, most drivers map a DATETIME to a java.sql.Timestamp, so using getTimestamp() is probably your best bet. If this doesn't work, you can probably use getString(), as that is often supported even if no other getXXX() methods are. You may be able to get a String representation of the date and time, which you can then parse with a DateFormat object to get the Date you wanted in the first place. It would be an inefficient way to go about getting a datetime, but it should work.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic