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>


Danes wrote:

> Maybe I am just dizzy but I thought that 600 seconds is 10 minutes...
> 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;

minute is not english, and therefore probably wrong syntax. Now, who's shitty?

-- 

Regards,
Frank van Bortel
Received on Wed Aug 25 2004 - 17:18:28 CEST

Original text of this message