Is DATE NOT NULL DEFAULT NOW() legal??

Hi there. I'm getting stuck on what seems only too simple to me: CREATE TABLE Waverley.MemberPrice ( PriceID TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, Price FLOAT(5,2) NOT NULL, ActivePrice TINYINT UNSIGNED NOT NULL DEFAULT 1, CreatedDate DATE NOT NULL DEFAULT NOW(),

SV: Is DATE NOT NULL DEFAULT NOW() legal??

- Från: Pete, Rose Kristina [mailto:[EMAIL PROTECTED]] Skickat: den 21 november 2001 10:25 Till: [EMAIL PROTECTED] Ämne: Is DATE NOT NULL DEFAULT NOW() legal?? Hi there. I'm getting stuck on what seems only too simple to me: CREATE TABLE Waverley.MemberPrice ( PriceID TINYINT UNSIGNED