Monday, August 5, 2013

how to get the Last Day of Current Week in sql

To get the Last Day of Current Week in sql server

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

No comments:

Post a Comment