jdbc, acces and dates

From: Bart Verdonck (bart.verdonck_at_howest.be)
Date: 03/28/04

  • Next message: Chris: "Re: jdbc, acces and dates" 
    Date: Sun, 28 Mar 2004 21:36:59 GMT

    Hi, I'm new to this newsgroup...

    How can I write a date/time to my acces database?
        Jdbc only supports java.sql.Date witch doesn't saves the time and
    java.sql.time witch doesn't saves the date.

    I've also tried to write the date with there long-values(milliseconds) by
    setlong(int,long) but then jbdc tells me he doens't support setlong for
    acces.

    Can someone tell me the right way to write those date into my acces db?

    Regards,
    BV

  • Next message: Chris: "Re: jdbc, acces and dates"

    Relevant Pages

    • Re: jdbc, acces and dates
      ... > How can I write a date/time to my acces database? ... > java.sql.time witch doesn't saves the date. ... Now use the getTimeInMillis member function to extract the time in ...
      (comp.lang.java.databases)
    • Re: jdbc, acces and dates
      ... > How can I write a date/time to my acces database? ... > Jdbc only supports java.sql.Date witch doesn't saves the time ... > java.sql.time witch doesn't saves the date. ... Access will discard the nanoseconds part and save the years, months, ...
      (comp.lang.java.databases)