Progress
SQL-92
Guide and Reference
NEXT_DAY Function
Returns the minimum date that is greater than the date corresponding to the first argument where the day of the week is the same as that specified by the second argument.
SYNTAX
EXAMPLE
This example illustrates the NEXT_DAY function:
NOTES
- The first argument to the function must be of type DATE.
- The second argument to the function must be of type CHARACTER. The result of the second argument must be a valid day of the week (’SUNDAY’, ’MONDAY’ etc.).
- The result is of type DATE.
- If any of the argument expressions evaluate to null, the result is null.
COMPATIBILITY
Progress Extension
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |