Re: HELP: DateTime problems

From: Alan D. Mills <alanm_at_uk.europe.mcd.mot.com>
Date: 1997/12/30
Message-ID: <01bd153e$d40672f0$73d0658c@ukmhdam>#1/1

I haven't tried this but...

In Oracle a date (including time) is stored as the number of days since the year dot (or whatever it is).

Take this floting point number and multiply it by the number of seconds in a day (24*60*60). This then gives the number of seconds since year dot. truncate (or round) this value from both Delphi and oracle and you should lose your fraction of a second rounding issue.

Hope this idea helps

Alan

Geoffrey Callaghan <callagha_at_cs.fsu.edu> wrote in article <689595$pk5$1_at_news.fsu.edu>...
> I am having a problem reconciling times between Delphi 1.0 and Oracle
7.3.
> Apparantly, Delphi uses a double to hold a Date/Time value, whereas
Oracle
> only goes down to the seconds level. Occasionally, this causes two time
> values that should be equal to register as unequal.
>
> Is there some way to ensure that Oracle doesn't look beyond the seconds
> level in a date comparison? From what I've read, it shouldn't be doing
> that anyway, but I've run out of ideas.
>
> Geoff Callaghan
> callagha_at_cs.fsu.edu
>
Received on Tue Dec 30 1997 - 00:00:00 CST