Unfortunately CONVERT() returns char field, and TTOD(),as Barbara mentioned, has nothing to do with SPT...
If I have a remote view, I can change the field type from T to D. Can I do something similar with the SPT cursor?

>>>Is there a way to convert datetime to date fields in SPT cursor?
>>
>>Would TTOD() do what you want?
>>
>>SELECT TTOD(tMyDateTime) AS dMyDate...
>
>You can only use functions that the back end will understand for SPT. I think CONVERT() may be what's needed here.