Re: next day function
From: Zoom Zoom Zoom <nospam_at_nospam.com>
Date: Tue, 23 Oct 2001 05:11:14 GMT
Message-ID: <SZ6B7.57939$gT6.29735981_at_news1.rdc1.sfba.home.com>
Date: Tue, 23 Oct 2001 05:11:14 GMT
Message-ID: <SZ6B7.57939$gT6.29735981_at_news1.rdc1.sfba.home.com>
SELECT (sysdate + 1) FROM dual;
"lunibuni" <rubilin_at_hotmail.com> wrote in message
news:5eba39de.0110222014.3c2f8405_at_posting.google.com...
> How do make oracle recognise the next day?
>
> I tried
>
> SQL> select next_day(sysdate) from dual;
> SELECT NEXT_DAY(SYSDATE) FROM DUAL
> *
> ERROR at line 1:
> ORA-00909: invalid number of arguments
>
> Also
>
> SQL> select next_day(sysdate, 1) from dual;
>
> NEXT_DAY(
> ---------
> 28-OCT-01
>
> but it's next WEEK and 1 day.
>
> What is the code for the next day?
>
> Ruby
Received on Tue Oct 23 2001 - 07:11:14 CEST