How can I store only time with timezone in Sequelize?

Question

I need to store only time with timezone in Sequelize ORM using "postgres" dialect

`time with timezone` is pretty much useless. Is that really what you are saving or are you using a `timestamp`? — Adrian Klaver, Mar 06 '22 at 22:04
Just do it: https://www.postgresql.org/docs/current/datatype-datetime.html — Frank Heikens, Mar 06 '22 at 22:04
I am using Sequelize ORM, and I did not found any type to store only time with timezone. — Oleksandr Petryk, Mar 06 '22 at 22:06
There are Sequelize data types - https://sequelize.org/v5/manual/data-types.html — Oleksandr Petryk, Mar 06 '22 at 22:06
Don't use `time with time zone` (`timetz`). It's broken by design and officially discouraged. See: https://stackoverflow.com/a/23300611/939860 — Erwin Brandstetter, Mar 06 '22 at 23:29

score 0 · Accepted Answer · answered Nov 08 '22 at 07:36

0

You can extend DATE or TIME DataType of Sequelize like this and declare your custom type or just put in the raw datatype like this

answered Nov 08 '22 at 07:36

roneo

1 Answers1