next day function
From: lunibuni <rubilin_at_hotmail.com>
Date: 22 Oct 2001 21:14:24 -0700
Message-ID: <5eba39de.0110222014.3c2f8405_at_posting.google.com>
Date: 22 Oct 2001 21:14:24 -0700
Message-ID: <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
Also
SQL> select next_day(sysdate, 1) from dual;
NEXT_DAY(
*
ERROR at line 1:
ORA-00909: invalid number of arguments
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 - 06:14:24 CEST