🚀 go-pugleaf

Hi!

I have been using a type Date/Time to store dates in MS-Access. I insert
dates as strings using a long format. The format used for the "General Date
Format" in Access seem to agree with that in the Windows Control Panel
Settings.

When I do the type of calculation you need, I parse the string back into a
Date, using a SimpleDateFormat. Not elegant, and not thoroughly tested, but
it seems to work.

Bye,

Mich�le.

"Randy K. Secrist" <r.secrist@m.cc.utah.edu> wrote in message
news:zC3p7.63$%W3.128769@news.uswest.net...
> Help!
>
> Does anyone know how to get the number of exact days since or before a
> specific time period?  If you think you can help, let me describe what I
am
> doing below...
>
> I am inserting rows into an access database.  One of the columns I am
adding
> is a date field.  Normally using Oracle or DB2, I can instantiate a
> java.util.Date, and insert the variable directly in the insert statement,
> and the correct date gets inserted into the database.
>
> However, in this case, the people I am doing a program for are set on
using
> MS Access.  *Sigh*.  The driver throws an exception if I use a
> java.util.Date, and if I use a java.sql.Date it successfully inserts the
> field into the database, but the wrong date is added to the row.  So,
after
> experimenation, i noticed that to get the correct date into the database,
> the SQL insert statment must have the date fields is just really a regular
> integer that looks like this:
>
> 0 being December 30 1899
> 1 being December 31 1899
> 2 being Jan 01, 1900
> 3 being Jan 02, 1900 etc.
>
> 25569 being Jan 01, 1970
>
> Since java tracks time in miliseconds from Jan 01 1970 - 12:00 AM being
> around 2703600000 miliseconds, i started to do  this the hard way - to get
> the number of days since 01/01/1900 from the number of miliseconds since
> 1970 - writing all kinds of methods to divide and get the miliseconds
right.
>
> So far this work around seems to work for 1900 to 2100 years, but if I go
> back far in time, say to 1700 it starts getting off by a few days.  For
all
> i know it has to do with leap years, and the such.  Basically I don't want
> to write a whole date class just to get the number of days... does anyone
> have solutions that could save me a lot of time and hassle?  I'd really
> appreciate it....
>
> Randy Secrist
>
>
>
>