"CAST(Start_Date as SMALLDATETIME) does not make that I want.I just want to
display day,month and year not hour or minute with this format dd/mm/yyyy.
Thanks a lot.
"Aaron Bertrand - MVP" <com> wrote in message
> Sounds like you may be confused about datetime vs. smalldatetime?
> Converting a datetime will only shave off the seconds/milliseconds and[/ref]