>>>>MartinaJ >>> >>>Thank you. Your code is even shorter than mine using DATEADD(). >> >>Your code should never be used in production as it's non-sargable. Using CAST(dateTimeColun as date) >>is OK. >>Or you can use what Michel suggested, it's a proven approach. > >non-sargable? En ingles, por favor :)
