Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Convert Datetype from Access database to Java 'DATETIME'

 
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.


 
Ganapathi Srinivasan
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
If you are using JDBC ODBC bridge driver, then getDate function will work properly. It is just that it shall return a java.sql.Date object without any time info. If you do not need the time info, you can use the getDate method itself. I do not foresee any problem for getDate method with Access DateTime value.
Hope I am clear.
Regards,
Ganp.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic