Try with the SQL convert function:

select convert( char(10), yourdatefield, 120 ) from yourtable



>Hello, everyone
>
>I am working with MSDE - it doesn't have DATE datetype. I need the fields from the views to be DATE, not DATETIME. I know I can do this with DBSETPROP, but how to do that for a cursor obtained with SPT?
>
>Thank you