you can specify DATE or TIME only once each

  Explanation:   You  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.