Here is how we get first day and last day of the year.
DECLARE @Year int set @Year = 2018 select DATEADD(year,0,DATEADD(year,@Year-1900,0)) /*First Day of the year*/ select DATEADD(day,-1,DATEADD(year,1,DATEADD(year,@Year-1900,0))) /*Last Day of the year*/
We can also get Year dynamically from SQL by passing current date. This works form SQL 2005 and above.
SELECT Year(getdate())
No comments:
Post a Comment