title: How can I store just the TIME on MySQL with Sequelize
body: <p>How can I store just the Time HH:MM:SS with sequelize?
  I tried it with the Time as a String and also as a Date Object, but I always get an Error.
  this is my function:</p>
  
  <pre><code>const dateCollection = await bookingTime.create({
              date: element.date,
              timeFrom: "12:00:00" || element.timeFrom,
              timeTo: element.timeTo
          })
  </code></pre>
  
  <p>The "12:00:00" is just for Test purpose.</p>
  
  <p>And this is My Sequelize Model:</p>
  
  <pre><code>timeFrom: {
          type: DataTypes.TIME,
          allowNull: false,
      },
      timeTo: {
          type: DataTypes.TIME,
          allowNull: false,
      },
  </code></pre>
  
  <p>My Error:</p>
  
  <pre><code>"original": {
      "code": "ER_TRUNCATED_WRONG_VALUE",
      "errno": 1292,
      "sqlState": "22007",
      "sqlMessage": "Incorrect date value: 'Invalid date' for column 'date' at row 1",
      "sql": "INSERT INTO `bookingTime` (`id`,`date`,`timeFrom`,`timeTo`) VALUES (DEFAULT,?,?,?);",
      "parameters": [
          "Invalid date",
          "12:00:00",
          "13:00:00"
      ]
  },
  </code></pre>
  
  <p>DDL:</p>
  
  <pre><code> CREATE TABLE `bookingTime` (
    `id` int(13) NOT NULL AUTO_INCREMENT,
    `date` date DEFAULT NULL,
    `timeFrom` time DEFAULT NULL,
    `timeTo` time DEFAULT NULL,
    `bookingID` int(11) NOT NULL,
    `machineID` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `FKmachineBT_idx` (`machineID`),
    KEY `FKbookingBT_idx` (`bookingID`),
    CONSTRAINT `FKbookingBT` FOREIGN KEY (`bookingID`) REFERENCES `booking` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `FKmachineBT` FOREIGN KEY (`machineID`) REFERENCES `machine` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) 
  </code></pre>
  
  <p>Thanks in advance for any Answers</p>