tsql - w3toppers.com

How to calculate age in T-SQL with years, months, and days

Here is some T-SQL that gives you the number of years, months, and days since the day specified in @date. It takes into account the fact that DATEDIFF() computes the difference without considering what month or day it is (so the month diff between 8/31 and 9/1 is 1 month) and handles that with a … Read more

SQl CASE Statement

Something like.. ORDER BY CASE WHEN ISDATE(DateTime) = 1 THEN CASE DateTime WHEN <= ‘2016-03-01’ THEN 1 — Preseason WHEN >= ‘2016-03-31’ THEN 3 — PostSeason ELSE 2 END — Season ELSE 4 END, — Not a date, figure out how to handle DateTime