• For what its worth.... from my 'T-SQL Shortcuts' scripts I found the following:

    /*Per SQL GURU Itzah-Ben Gah the fastest way to extract the date portion of a DateTime value is:*/

    SELECT CONVERT(DATETIME,Floor(Convert(FLOAT, GetDate() ) ) )

    I don't recall if Itzah was referring to a SQL Serve 2XXX specific platform or T-SQL in general and I did not note anything about specific SQL versions along with this shortcut.

    Kindest Regards,

    Just say No to Facebook!