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.
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.
subject: Convert Datetype from Access database to Java 'DATETIME'