SET CENTURY is irrelevant in this case

lcDateTimeNow = DATETIME()
Insert Into MyTable (MyDateTimeFiled) Values (lcDateTimeNow )

>I want to store the current Datetime from within a foxpro prg to a Sql Server dattime field
>
>i.e. Insert Into MyTable (lcDateTimeNow) Values (MyDateTimeFiled)
>
>MyDateTimeField is a DateTime field in the Sql Server Table
>
>
>What do I puit into lcDateTimeNow
>is it lcDateTimeNow = DateTimeNow()
>Do I need to have Set Cent on
>