Select StartDate=dbo.get_week_start(GETDATE)) Select EndDate=dbo.get_week_end(GETDATE()) Here dbo.get_Week_Start and dbo.get_week_end are user defined functions to know start date of the week and end date of the week for the current date.