Hi Yew,
in addition to James' suggestion of using datepart in the query, SQL2008 does in fact have a date column type:
http://www.sqlteam.com/article/using-the-date-data-type-in-sql-server-2008. Since you are using SPT, you are probably not updating the cursor (by setting the cursor properties to support buffering, etc.), so datepart ought to work for you.
hth,
Hank
>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