0 Replies Latest reply: Nov 30, 2007 6:36 PM by 807600 RSS

    Change date column format in Microsoft Access db?

    807600
      Hi,

      I'm completely new to Java so I'm unsure how easy\hard this my question is...

      A Java application I'm working on creates an Access mdb (through some 3rd party API's) in that mdb there are some columns of type date with values of date-time. The user does not want to see the time when they create reports in Access.

      So two solutions would be to either (a) set the column format to Medium Date or (b) truncate the values in the row.

      Method (b) should be much quicker since it is not altering any values...but is this possible to do in Java? I'm not sure even where to start.

      Also I tried method (b) using sun.jdbc.odbc.JdbcOdbcDriver but have had some issues (just not updating values)...not sure what the cause is so I'll continue to bang away at that (unless someone has some sample code that would be great also).


      Thanks,
      Frank