Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Write a query to find the next day : finds the date when next day of week(e.g. mon to sun) will come begg with passed date

Posted By: Libby Hughes     Category: Oracle     Views: 3756

Write a query to find the next day : finds the date when next day of week(e.g. mon to sun) will come begg with passed date .

Write a query to find the next day : finds the date when next day of week(e.g. mon to sun) will come begg with passed date. 

SELECT next_day(DOB,'sunday') FROM PSTUDENT;

Output : 

NEXT_DAY(
20-MAR-83
10-OCT-82
26-JUN-83
26-SEP-82
24-FEB-80
23-MAR-80
24-JUL-83
  
Share: 



Libby Hughes
Libby Hughes author of Write a query to find the next day : finds the date when next day of week(e.g. mon to sun) will come begg with passed date is from London, United Kingdom.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!