>Hi,
>
>I'm having trouble using an SQL INSERT statement to insert the time into a DATETIME field in a FoxPro table. ANy ideas of the syntax? Thanks!
>
Tim,

What seems to be a problem? Here're some examples.

INSERT INTO mytable (dtField) VALUES (DATETIME(2004,01,12,12,45,00))
INSERT INTO mytable (dtField) VALUES ({^2004/01/12 12:45:00})
INSERT INTO mytable (dtField) VALUES (ltDateTimeVar)