>I retrieve a cursor from SQL Server database using SQLEXEC. One of the fields in the table is smalldatetime. I would like to convert it to Date type so that my UI does not show the time portion. I tried to use DbSetProp() function but it requires a database.
>Is there a way to convert this column on-the-fly while retrieving from SQL Server?

No.

> Or should I use ALTER TABLE to change the column type?

It'll not work if cursor has fields with long names.