Thursday, October 4, 2018

SQL SERVER - How to get week number

select getdate(), datepart( wk, getdate() )
Output:
----------------------- -----------
2018-10-04 06:32:01.717 40

(1 row(s) affected)

No comments:

Post a Comment