p.s.  If you don't understand the code and how it does what it does, post back.  You're the one that will have to support the code.

This should do it for you

--===== Create a sample using variables.
DECLARE  @OrderDate NUMERIC(18,0)   = 118063
        ,@OrderTime FLOAT           = 11456
;
--===== This solves for...

K.  I'm on it.  Back in a few.

I believe you meant "not" rather than "now".

However, your first example is also non-deterministic.  Here's the proof.

Create