>How can I insert current datetime in my sql table via VFP ?
>
>year, month, day, h, m,s
>
>Please help me insert date in line below:
>
>cSQL = "UPDATE reembolso set reg_correios= ?m.reg_correios, env_ect = 1 where code = ?m.code, datetime = "
>
>asa=SQLEXEC(lnHandle,cSQL )
>
>I am not sure if I have to convert it.
>
>Moises


When I worked with DB2, it had an extended DATETIME function which included an extra 6 digits at the end of the normal format so as to provide better resolution. We converted that fo C(26) and retrieved it that way "MM/DD/YYYY HH:MM:SS.ZZZZZZ". We instructed the remote DB engine to do this so on our queries and updates they were always stored and retrieved that way.