I thought of creating a simple function for this operation, in T-SQL. Function Name: Next_Day Input Params: @FromDate - Date from which you wish to get the next day; @DayNumber - Day of week for which you wish to get the next day (6=>Saturday, 7=>Sunday) Operation: SELECT dbo.Next_Day(GETDATE(),6) //Returns the next Saturday (6) from today Function: Function body … Continue reading T-SQL equivalent for NEXT_DAY() of ORACLE
Check out my video on MindTree Certified Project Manager, done on behalf of MindTree Movie Club.
Check out my video on a First Time manager's state of mind.
Check out my video on MindTree's venture with Sambhav Foundation.