>Hi,
>Is there a function i can use to convert a Datetime field in visual foxpro to the format used by Sql Server 2000
>i.e.
>Visual FoxPro Format : 03/04/2003 15:30:21
>Sql Format : 2003-04-03 15:30:21How are you sending your datetime value?, by SPT you can use "?" for casting.
lnCurrTime = DATETIME()
SQLExec(lnConn,"SELECT iid,name from customer WHERE lastBuy>=?ldCurrTime")
HTH