Test it, just be sure to use a large dataset,...

Okay, read: https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql

Duplicate post, post answers here.

I was awake during the time change, so I still got 8 hours sleep, no problem.  Time to move on.

If the requirements change then obviously the code has to change.  Sometimes you just need what works rather than trying to code to a bunch of what ifs that may...

Well, sort of hard to help when we can't see what you see.  Could you post the query and execution plan (as an *.sqlplan file)?  It may also help to...