title: Datetime and Timestamp Issue while creating MYSQL Table
body: <p>I am trying to create mysql table in PhpMyAdmin in Hostgator server with the following information but it is showing error </p>
  
  <pre><code>Error : #1067 - Invalid default value for 'CreatedDate'
  </code></pre>
  
  <p>Table </p>
  
  <pre><code>  CREATE TABLE `tbl_sample` (
    `ID` int(11) NOT NULL  AUTO_INCREMENT,
    `Domain` varchar(100) DEFAULT NULL,
    `ClickUrl` varchar(600) DEFAULT NULL,
    `CreatedDate` datetime NULL DEFAULT now(),
    `ModifyDate` timestamp NULL DEFAULT NULL on update now(),
    PRIMARY KEY (`ID`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>The purpose of table is I need to enter only 'Domain' and 'ClickUrl' data using insert command remaining Id(autoincrement),CreatedDate(current date when inserting row),ModifyDate(when update the row) will automatically insert.</p>
  
  <p>The above table is executed successfully in mysql environment in my local system but it is not executing in the mysql environment in hostgator</p>