Can't they use datepart in the query?

>>Hi all
>>
>>My app is using MSSQL as DB. I need to create a cursor using SPT.
>>
>>Is there a way to convert datetime fields in MSSQL as date field in VFP cursor?
>>
>>Right now I have to do another SELECT with TTOD but this will slow performance as my cursor has some 300,000 records.
>>
>>I have tried the various CONVERT and CAST but there end up as Char field in VFP cursor.
>>
>>Is there any way to directly convert datetime fields to date fields with SQL Pass Thru?
>>
>>Your assistance and advice is really appreciated.
>>
>>Thanks & Best Regards
>
>No, as I just learnt reading this thread Re: Syntax for cursorsetprop to change field type Thread #1133437 Message #1133449