Last day of the current year

Kirthiga
Posted by Kirthiga under Sql Server category on | Points: 40 | Views : 1549
select DATEADD(YY,DATEDIFF(YY,-1,SYSDATETIME()),-1) [LastDay Of a Year]

Comments or Responses

Login to post response