>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))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.