• Also, you can add or subtract days like so:

    DECLARE @DateOnly DATETIME

    SET @DateOnly = CAST(FLOOR(CAST(GetDate() AS FLOAT)+1) AS smallDATETIME);

    print @DateOnly

    Prints just like the original did, but a day later. Subtract 2 and you get two days earlier.

    Since DateAdd is apparently high overhead, it seems like a good alternative.

    *******************
    What I lack in youth, I make up for in immaturity!