This will select the date part using italian date (dd-mm-yyyy)

  Select convert(nvarchar(10),DateField,105)

And this will extract the time

  Select convert(nvarchar(11),DateField,114)

For more info check cast and convert in BOL.

HTH,

Enmanuel

>Dear Expert,
>
>I am very new to SQL server, I have a datetime field, how do I get only the
>date or time value using SQL command? ..
>
>Pls help, TIA
>
>Regards
>Teddy