troube inserting DATETIME

I have a table that contains two datetime attributes (as well as some ints and varchars)

I try to load records with an Insert statement similar to the following:
Insert into xx values( ..., "02-02-00", CURRENT_TIMESTAMP, ...)

I've looked at manual and searched for examples to no avail...seems most are geared for retrieving data not inserting.

The CURRENT_TIMESTAMP works but numerous variations of dates don't. I've tried adding "02-02-00 00:00:00", "0000-02-02", single quotes instead of double, etc. etc.

am i missing something (err don't answer that <grin>


TIA,

Roark:-)

Do you mean to be adding '0000-02-02' or '2000-02-02'? Date wants to be a year-month-day format.