I had gathered that what you hoped was that you could remove the 00:00:00.000 from the result, but as I stated, with a datetime data type, you'll always get the time, even if it's 00:00:00.000.

To remove the 00:00:00.000, you either need a date only datatype (which is only available starting with 2K8) or to change to the char datatype (which you did in your last example). BTW, please note in that last example, it isn't a date, it's a string.

The point of this wasn't to remove the time portion as in the 00s but just to truncate the time so that the result is easier to work with.

e.g. Select xx from SalesOrders where OrderDate >= FLOOR(CAST(GETDATE() AS FLOAT))