>sqlserver's date fields come with datetime type.
>how can i have only date instead of datetime ?

In a view you can define the type of the result column as date. In a SPT cursor, you need to issue a 2nd select statement on your cursor where any datetime field would be selected through a ttod() or a Cast(datetimefield as date). If there's a better way to do it for SPT cursors, I'd like to know too.