Re: Date and Time arithmetic

From: Frank <fvanbortel_at_netscape.net>
Date: Tue, 11 Mar 2003 22:21:23 +0100
Message-ID: <3E6E5353.4040908@netscape.net>

Hendrik Lampert wrote:
> Hi,
>
> is there any way in oracle to get the number of seconds, minutes, and hours
> between 2 date columns, e.g 11.03.2003 10:00:00 and 09.03.2003 08:15:20?
>
> thx
> hendrik
>
>

time2 - time1; recalculate as the outcome will be in days.

to_date('09.03.2003 08:15:20','MM.DD.YYYY HH:MI:SS') - theOtherOne. Maybe use 'MM.DD.YYYY HH24:MI:SS' as format mask, if you have 24hr formats (which is not obvious from your posting)

-- 
Regards, Frank van Bortel

Received on Tue Mar 11 2003 - 15:21:23 CST