I addition to Les's method you can use:

cVFPDate=DATE()

SQLEXEC(gnhandle,'update oracle_table set datefield=?cVFPDate')

Then let the odbc driver take care of the conversion.

Prefered because it uses bind variables so SQL can be reused efficeiently.

As les mentioned use the TO_CHAR oracle function to change the format on the oracle server side..