1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Sql to get business days

Discussion in 'SQL PL/SQL' started by karthik.rajashekaran, Dec 14, 2015.

  1. karthik.rajashekaran

    karthik.rajashekaran Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi ,

    Below is the data from business calendar table .. I need to get Run_date which is currentdate+ 9 business date that is from below table it is 28 DEC 2015.
    If sysdate not found in the below table then use the next date available + 10 days

    View attachment 29462
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    What have you tried to get this information? Post your work so far and we can see where you may have gone wrong.