You can use CONVERT() function for special conversion of datetime values to the charcter data type.

SELECT CONVERT(varchar(12), dt, 101) AS justdate, 
		CONVERT(varchar(12), dt, 108) AS justtime

>dear all,
>
>
>i had webform which execute a sql statement that contains date_attendance field (eg 9/14/2002 1:30 PM)
>what if i want to show just the time format only or the date only (eg 1:30 pm).
>
>kindly help,
>
>TIA
>
>Budi