Re: Subtracting Dates

From: Jim Kennedy <kennedy-down_with_spammers_at_no_spam.comcast.net>
Date: Tue, 29 Jul 2003 02:09:15 GMT
Message-ID: <fHkVa.2547$Ho3.756@sccrnsc03>

If you subtract 2 dates you get the days between each date with the fraction being the fraction of a day. So just do the math. Jim

"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
>
> --
> Posted via http://dbforums.com
Received on Mon Jul 28 2003 - 21:09:15 CDT

This message: [ Message body ]
Next message: Phil Singer: "Is perfection attainable?"
Previous message: Gary: "Re: Insert a new row into a talbe using Addnew method via Oracle OLEDB Provider"
In reply to: carlos_lotero: "Subtracting Dates"
Next in thread: Mark D Powell: "Re: Subtracting Dates"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US