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