Would it not be easier to just cast both variables to the time data type and catch any error (or is there IsTime function?)
james.brown.iphone - Tuesday, April 18, 2017 11:45 AM
Casting a time to a datetime does not throw an error, that is the point of the article. IsDate returns 1 on a valid time value.
GeorgeCopeland - Thursday, April 13, 2017 1:54 PM
Heh... Agreed. And worse than that, it is thinking like this that gave us the crippled DATETIME2 data type, which ultimately gave rise to the need got DATEDIFF_BIG.
Change is inevitable... Change for the better is not.
Viewing 3 posts - 16 through 17 (of 17 total)