>Hi
>
>What's wrong with the following date and time values while compiling application.
>
>Compiling d:\village\progs\datime.prg
>INSERT INTO MyTable (dtValue, dValue) VALUES ({12/11/2000 02:59:02 AM},{12/11/2000})
>Error in line 111: Ambiguous date/datetime constant. Use the format:
> {^yyyy-mm-dd[,][hh[:mm[:ss]] [a|p]]}
>
>Thanks/Regards - Saif

INSERT INTO MyTable (dtValue, dValue) VALUES ({^2000/11/12 02:59:02 AM},{12/11/2000})

but I prefer this:

INSERT INTO MyTable (dtValue, dValue) VALUES (DATETIME(2000,11,12, 2, 59, 2),DATE(2000,11,12))