I have a table with dates which is of type "datetime", but entering in SQL code such as :

INSERT INTO test (code, date)
VALUES (34, '08/08/03')

produces an error allong the lines of: You cannot assign a value of type 'integer' to a column of type 'date'. Explicitly convert the value to the required type

I've tried changing '08/08/03' to 'Aug-08-2003' and '8/8/03' and '08/08/2003' etc etc... does anyone have any ideas why this isn't working??

oh don't worry... i'm such a noob was writing to the wrong table and didn't notice...sorry everyone