title: How can I set the default value of a field as '0000-00-00 00:00:00'?
body: <p>How can I set the default value of a field as '0000-00-00 00:00:00'? If we can't use '0000-00-00 00:00:00' as the default? What is the <strong>basic</strong> valid tiemdate?</p>
  
  <p>For instance, this is the SQL for creating my article table,</p>
  
  <pre><code>-- -----------------------------------------------------
  -- Table `article`
  -- -----------------------------------------------------
  DROP TABLE IF EXISTS `article` ;
  
  CREATE TABLE IF NOT EXISTS `article` (
    `article_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `url` VARCHAR(255) NOT NULL,
    `title` VARCHAR(255) NOT NULL,
    `date_from` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Set the article as new or featured from a datetime.',
    `date_to` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Set the article as new or featured to a datetime.',
    `backdated_on` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The manual datetime that is modified or input by the user.',
    `created_on` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The permanent datetime when the article is created.',
    `updated_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'The datetime when the article is updated on.',
    PRIMARY KEY (`article_id`, `parent_id`, `template_id`),
    UNIQUE INDEX `url_UNIQUE` (`url` ASC))
  ENGINE = MyISAM
  AUTO_INCREMENT = 66
  COMMENT = 'Entity that holds the article with one-to-one properties.';
  </code></pre>
  
  <p>I get this error when I run this query,</p>
  
  <pre><code>#1067 - Invalid default value for 'date_from' 
  </code></pre>