Re: Time range calculations

From: Diego Buendia <dbuendiab_at_yahoo.es>
Date: 14 Jan 2004 13:17:18 -0800
Message-ID: <71e97616.0401141317.3c0f4132@posting.google.com>

Thank you, Rene. Beginnings are difficult. I've found this solution from your suggest:

ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI' and then

INSERT INTO Tb_Schedules (dt_1, dt_2) VALUES ('1-ENE-2004 08:00', '1-ENE-2004 20:00' ) It works also with the mask you proposed. Thanks again and see you!

Barcelona, Spain

>
>
> Try a modification of
>
>
> select
> to_char(
> trunc (sysdate) +
> (dt_2-trunc(dt_2)) -
> (dt_1-trunc(dt_1)),
> 'hh24:mi:ss'
> )
> from
> tb_schedule;
>
>
> hth
> Rene
Received on Wed Jan 14 2004 - 15:17:18 CST