>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.
>VFP Format : 03/04/2003 15:30:21
>Sql Format : 2003-04-03 15:30:21
>
>
>Tnx
>Anthi
Hi Anthi,
Try
ltDt = {03/04/2003 15:30:21}
? TRANSFORM(TTOC(ltDt,1), "@R 9999-99-99 99:99:99")
BTW, SQL Server understands many different formats of date, not just this one.
--sb--