title: MYSQL CURDATE() Not working
body: <p>I have the following table:</p>
  
  <pre><code>CREATE TABLE Trans (
      tranID int NOT NULL AUTO_INCREMENT,
      tranDate datetime NOT NULL DEFAULT  CURDATE(),
      amount INT,
      account_number INT,
          FOREIGN KEY(account_number) REFERENCES Account(account_number) ON DELETE CASCADE,
      PRIMARY KEY(tranID)
  
  );
  </code></pre>
  
  <p>and every time a trans happens the date is inserted so it has a timestamp. However, I am getting an issue when trying to implement it. I got the CURDATE example off the W3C schools website to make my life easier but I cannot seem to get it to work. </p>