DECLARE @dt datetime SET @dt = GETDATE() -- begining of the month date SELECT DATEADD(mm, DATEDIFF(mm, 0, @dt), 0) -- begining of the year date SELECT DATEADD(year, DATEDIFF(year, 0, @dt), 0) -- e.t.cBTW, this and some other tips and tricks has been published in 2004 issues of UT magazine.