Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones Finding New Years Eve RE: Finding New Years Eve
john.arnott
SSChampion
Points: 11882
More actions
January 4, 2013 at 9:38 am
#1573827
Or, since Nigel has led us outside the box....
Select convert(datetime, rtrim(Datepart(year,getdate())-1)+'-12-31')
Yeah, I cheat by using rtrim() as a quickly coded forced conversion to a string.