Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 74 of 166
next_day::=
next_day
NEXT_DAY
returns the date of the first weekday named by char that is later than the date date
. The argument char must be a day of the week in the date language of your session, either the full name or the abbreviation. The minimum number of letters required is the number of letters in the abbreviated version. Any characters immediately following the valid abbreviation are ignored. The return value has the same hours, minutes, and seconds component as the argument date.
This example returns the date of the next Tuesday after February 2, 2001:
SELECT NEXT_DAY('02-FEB-2001','TUESDAY') "NEXT DAY" FROM DUAL; NEXT DAY ----------- 06-FEB-2001
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|