>Thanks, Naomi
>That looks good.
>I found this too- it strips the time off
>:
> CAST(FLOOR(CAST(mydatetimecolumn AS float))AS datetime)
I don't know where you found it, but forget it right away. Don't ever try to use function on the field - it will make your query non-sargable.
Please make sure to read the short blog by Aaron Bertrand I referenced (the second reference).
If it's not broken, fix it until it is.
My Blog