Re: PL/SQL Intervals are dizzy
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 25 Aug 2004 17:18:28 +0200
Message-ID: <cgia7l$fr9$1_at_news1.tilbu1.nb.home.nl>
Date: Wed, 25 Aug 2004 17:18:28 +0200
Message-ID: <cgia7l$fr9$1_at_news1.tilbu1.nb.home.nl>
Danes wrote:
> Maybe I am just dizzy but I thought that 600 seconds is 10 minutes...
minute is not english, and therefore probably wrong syntax.
> Obviously not! Or maybe PL/SQL is just dizzy.
>
> SQL> declare
> 2 blah1 interval day to second := interval '600' second;
> 3 blah2 interval day to second := interval '10' minute;
-- Regards, Frank van BortelReceived on Wed Aug 25 2004 - 17:18:28 CEST