First day of the current year

Kirthiga
Posted by Kirthiga under Sql Server category on | Points: 40 | Views : 759
select DATEADD(YY,DATEDIFF(YY,0,SYSDATETIME()),0) [FirstDay Of a Year] 

Comments or Responses

Login to post response