Hello,

no .. not until VFP8 ... there you can do it in the cursoradapter class .. just setting CursorSchema should be sufficent

in older version you can do it also but not with SQL Pass Through .. only in Remote Views ->
DBSETPROP('yourView.yourDateTime','Field','DATATYPE','D')

if you have to stick with SQL Pass Through the only option i see left is
CONVERT()ing (MS-SQL) or accordingly TO_CHAR()ing (Oracle) in the SQL statement to character type with appropiate date formatting so it displays correct ..

Regards

Christian