DataType.TIME doesn't insert into Postgres correctly

[sebastiankade]

Issue Description

What are you doing?

Upgrading to Sequelize 6 from 4.x.

We use DataType.TIME for TIMESTAMP postgres fields.

@AutoColumn({ type: DataType.TIME })
  practiceTime: Maybe<Date>;

However when this is getting inserted into sql it is being inserted as a date:
invalid input syntax for type time: "2021-05-18T08:00:00.000+00:00"

Time syntax should be: HH:MM:SS

What do you expect to happen?

DataType.TIME should insert fields in HH:MM:SS format

What is actually happening?

Trying to insert as full date strings.

Environment

Sequelize Versions:
"sequelize": "^6.6.2",
"sequelize-cli": "^6.2.0",
"sequelize-typescript": "^2.1.0",

• Node.js version: v12.16.1
• Operating System: Mac
• If TypeScript related: TypeScript version: 3.7.5

Issue Template Checklist

How does this problem relate to dialects?

• I think this problem happens regardless of the dialect.
• I think this problem happens only for the following dialect(s):
• I don't know, I was using PUT-YOUR-DIALECT-HERE, with connector library version XXX and database version XXX

Would you be willing to resolve this issue by submitting a Pull Request?

• Yes, I have the time and I know how to start.
• Yes, I have the time but I don't know how to start, I would need guidance.
• No, I don't have the time, although I believe I could do it if I had the time...
• No, I don't have the time and I wouldn't even know how to start.

[github-actions]

This issue has been automatically marked as stale because it has been open for 7 days without activity. It will be closed if no further activity occurs. If this is still an issue, just leave a comment or remove the "stale" label. 🙂