**Update:** As noted in the comments, this method does not actually round, it truncates the datetime value. As feature complete as MS SQL Server may be, it really lacks some simple datetime rounding ...