Advertisement
jotaced

1stlastdayofYear

Jun 26th, 2013
325
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.13 KB | None | 0 0
  1. SELECT
  2.    DATEADD(yy, DATEDIFF(yy,0,getdate()), 0) AS StartOfYear,
  3.    DATEADD(yy, DATEDIFF(yy,0,getdate()) + 1, -1) AS EndOfYear
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement