Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't use timestamptz #21

Open
mine-tech-oficial opened this issue Sep 15, 2024 · 2 comments
Open

Can't use timestamptz #21

mine-tech-oficial opened this issue Sep 15, 2024 · 2 comments
Labels
enhancement New feature or request type request A request to add support for a PG type

Comments

@mine-tech-oficial
Copy link

I was looking at the supported types, and I saw that timestamptz (timestamp with time zone) isn't supported. When it is stored in the DB, it has the same information as timestamp, so maybe it could be possible to decode it into the same type as timestamp (#(#(Int, Int, Int), #(Int, Int, Int))), although when encoding I think there should be an option to input a timezone (maybe a type like (#(#(Int, Int, Int), #(Int, Int, Int), Int))

@giacomocavalieri giacomocavalieri added enhancement New feature or request type request A request to add support for a PG type labels Sep 22, 2024
@giovannibonetti
Copy link

giovannibonetti commented Oct 7, 2024

Perhaps a better encoding for timestampz could be based on Posix Time and Time zone, just like the Elm time package.

@lpil
Copy link
Contributor

lpil commented Dec 22, 2024

This would need to be solved in pgo and then pog before Squirrel can support this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request type request A request to add support for a PG type
Projects
None yet
Development

No branches or pull requests

4 participants