January 14th, 2000, 03:07 PM
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>
January 17th, 2000, 08:59 PM
Do you mean to be adding '0000-02-02' or '2000-02-02'? Date wants to be a year-month-day format.