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

NEXT_DAY ( date_expression, day_of_week ) 

EXAMPLE

This example illustrates the NEXT_DAY function:

SELECT NEXT_DAY (order_date, ’MONDAY’) FROM orders ; 

NOTES

COMPATIBILITY

Progress Extension


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095