Re: Subtracting Dates

Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0307281823.506f85f6_at_posting.google.com>...
> carlos_lotero <member33668_at_dbforums.com> wrote in message news:<3158472.1059425551_at_dbforums.com>...
> > Hello,
> >
> > I need to show the difference between dates in format: hh24:mi:ss.
> >
> > Thanks,
> >
> > Carlos
>
> Carlos, it is fairly simple. Subtract the older date value from the
> newer one. The result is days and fractions there of. Divide the
> base (or days) by 24 to get hours. Multiple the fraction by the
> number of minutes in a day to get minutes and parts there of.
> Multiple the fraction of a minute by 60 to get seconds.
>
> I am not at work so I do not have a computer available to provide a
> partial example, but if you need one after you play around with the
> above and no one else posts anything I will post one.
>
> HTH -- Mark D Powell --

Nice little misdirection there Mark. That should make any student programmers scratch their heads. I love it! Regular programmers will see it and say "oh, yeah he meant..."

Ed Prochak Received on Wed Jul 30 2003 - 15:46:32 CDT