Monday, August 5, 2013

how to get first day of current week in sql

To get first day of current week

SELECT DATEADD(WEEK,DATEDIFF(WEEK,0,GETDATE()),0)

No comments:

Post a Comment