Showing posts with label sql server - datepart(). Show all posts
Showing posts with label sql server - datepart(). Show all posts

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)