You can specify DATE or TIME only once each.

  Explanation:  You entered entered DATE date-number twice or TIME
  time-number twice in the SET DATE FORMAT statement.

  User Action:  Enter nothing, or enter DATE, TIME, or one of each
  with SET DATE FORMAT.