Re: simple way to compare date "intervals"

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 3 Sep 2004 11:52:03 +0100
Message-ID: <7765c897040903035213b9ff1d@mail.gmail.com>

On Thu, 2 Sep 2004 16:23:39 -0400, paula_stankus_at_doh.state.fl.us <paula_stankus_at_doh.state.fl.us> wrote:
> Would like to know if there is anyway to get 4 hours from sysdate for a =
> comparison:

doesn't

select SYSDATE - 4/24 from dual; work for you?

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
---
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004

Received on Fri Sep 03 2004 - 05:47:43 CDT