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

expr: support casting varchar -> timestamptz with timezone hour but not minute #12564

Closed
xiangjinwu opened this issue Sep 27, 2023 · 0 comments · Fixed by #13613
Closed

expr: support casting varchar -> timestamptz with timezone hour but not minute #12564

xiangjinwu opened this issue Sep 27, 2023 · 0 comments · Fixed by #13613
Assignees
Milestone

Comments

@xiangjinwu
Copy link
Contributor

xiangjinwu commented Sep 27, 2023

Example:

2023-09-27 15:40:14.295357+08

This is a mixture of ISO 8601 and RFC 3339, but is not fully compliant with neither and unsupported by chrono (unless a custom format is used) or speedate. However, it is the default output format of PostgreSQL.

  • 2023-09-27T15:40:14.295357+08: ISO 8601, with date/time separator as T rather than a space.
  • 2023-09-27 15:40:14.295357+08:00: RFC 3339, with timezone minutes.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant