Happy New Year! With every new year I think a little bit about time and dates, so let’s look at that in TSQL. Rounding Dates: Which way is best? Sometimes in TSQL you need to round a datetime value to the precision of either a day, hour, minute, or second. I realized recently that I [...]
Filed under: Performance, sql, SQLServerPedia Syndication | Tagged: DATE, DATEADD, DATEDIFF, DATEPART, DATETIME, Rounding, SMALLDATETIME, TSQL | Leave a Comment »
