Re: simple way to compare date "intervals"

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 3 Sep 2004 11:52:03 +0100

On Thu, 2 Sep 2004 16:23:39 -0400, paula_stankus@xxxxxxxxxxxxxxx
<paula_stankus@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx&subject=unsubscribe 
To read recent messages - //freelists.org/archives/oracle-l/09-2004

Other related posts: