Help with smalldateTime

Hello everyone,
I have in a table a field smalldatetime. The problem is that when I
select from table I need only the date without the time.
Is it possible not to show the time?
For example 06/02/2006 00:00:00 to be 06/02/2006.
Thanks a lotselect CONVERT(varchar(10), GETDATE(), 103)
HTH. Ryan
"Pumkin" <PopClaudia@.gmail.com> wrote in message
news:1139570322.012554.43930@.g47g2000cwa.googlegroups.com...
> Hello everyone,
> I have in a table a field smalldatetime. The problem is that when I
> select from table I need only the date without the time.
> Is it possible not to show the time?
> For example 06/02/2006 00:00:00 to be 06/02/2006.
> Thanks a lot
>|||Thanks a lot. It worked wonderfully