hi you might want to look at TIMESTAMP which does it all for you.
Peter > -----Original Message----- > From: Robert Adkins [mailto:[EMAIL PROTECTED] > Sent: 15 October 2004 20:23 > To: MySQL General List > Subject: Command that I believe should work... > > > ...but doesn't. > > I am attempting to create a table using the following... > > > CREATE TABLE INVOICE ( > INV_NUMBER INT PRIMARY KEY, > CUS_CODE INT NOT NULL REFERENCES > CUSTOMER(CUS_CODE), > INV_DATE DATETIME DEFAULT NOW() NOT NULL, > ); > > I receive an error message stating that there is an error with 'NOW()' > > Which doesn't make sense to me. I understand both Oracle and MS-SQL > Server use a similar format for putting the date and time into a field > when a new row is created. At least that is my goal. > > Is there a very different method of doing this under MySQL 4.0.21? > > Thanks for any assistance you may offer. > > -Rob > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]