I need to store only time with timezone in Sequelize ORM using "postgres" dialect
Asked
Active
Viewed 27 times
0
-
`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. – Petryk Oleksandr Mar 06 '22 at 22:06
-
There are Sequelize data types - https://sequelize.org/v5/manual/data-types.html – Petryk Oleksandr Mar 06 '22 at 22:06
-
Yes I need to store only time with timezone. – Petryk Oleksandr Mar 06 '22 at 22:08
-
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