Hi,
I'm not absolutely sure (I never use Access), but have you tried
java.sql.Timestamp? You can throw a java.util.Date into it (which has
everything from years to seconds), plus a nanoseconds. I assume
Access will discard the nanoseconds part and save the years, months,
days, hours, minutes, and seconds.

- --
Chris

You need a two-stage approach. First, create an object of the class
java.util.GregorianCalendar using the constructor which takes six
integer parameters to specify date and time:

public GregorianCalendar(int year,
                         int month,
                         int date,
                         int hour,
                         int minute,
                         int second)

Now use the getTimeInMillis member function to extract the time in
milliseconds since the epoch (1970 January 1 00:00:00 Universal Time),
and pass this as the argument to the constructor of a java.sql.Timestamp
object. You can now use the Timestamp object to insert the date and time
into your database.

java.util.GregorianCalendar allows re-use of the object to represent a
different date and time through the "set" function:

public final void set(int year,
                      int month,
                      int date,
                      int hour,
                      int minute,
                      int second)

Hope this helps.

David Harper
Cambridge, England