Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle NEXT_DAY Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: NEXT_DAY

Definition:
The Oracle NEXT_DAY function returns the date of the first weekday named by 'day_of_the_week' that is later than 'target_date'.

  • The return datatype is always DATE, regardless of the datatype of 'target_date'.

  • The argument 'day_of_the_week' 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.

  • The return value has the same hours, minutes, and seconds component as the argument date.

Example Syntax:

NEXT_DAY(target_date, day_of_the_week);



Example Usage:

This example returns the date of the next Friday after May 10, 2010:

SELECT NEXT_DAY('10-MAY-2010','FRIDAY') "NEXT DAY"
FROM DUAL;

NEXT DAY
-----------
14-MAY-2010



Related Links:

Related Code Snippets:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 102 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?