-- This is OK (What I Expect) -- Result: 1234.5678

DECLARE @F1 FLOAT

SELECT  @F1 = 1234.5678

SELECT CONVERT(DECIMAL(10, 4), @F1) 

-- This is OK (What I Expect) -- Result: 1235

DECLARE @F2 FLOAT

SELECT ...

Another approch is to just use a "delta time" between the test date and a predefined date (e.g., '1/1/2000') [in whatever units you want] and sort on the difference value.

For example, if "seconds"...