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

bug: confusing err when parsing ancient timestamptz #13611

Open
xiangjinwu opened this issue Nov 23, 2023 · 1 comment
Open

bug: confusing err when parsing ancient timestamptz #13611

xiangjinwu opened this issue Nov 23, 2023 · 1 comment
Assignees

Comments

@xiangjinwu
Copy link
Contributor

create table test (
  tz timestamptz
);

insert into test values ('0001-01-01 00:00:00Z');

will cause Parse error: Can't cast string to timestamp (expected format is YYYY-MM-DD HH:MM:SS[.D+{up to 6 digits}] or YYYY-MM-DD HH:MM or YYYY-MM-DD or ISO 8601 format).
'1969-01-01 00:00:00Z' is ok.

Originally posted by @xuefengze in #13496 (comment)

@github-actions github-actions bot added this to the release-1.5 milestone Nov 23, 2023
@xiangjinwu
Copy link
Contributor Author

Not useful in practice, but common when people tries to test edge cases.

@xiangjinwu xiangjinwu self-assigned this Nov 30, 2023
@xiangjinwu xiangjinwu modified the milestones: release-1.5, release-1.6 Dec 6, 2023
@xiangjinwu xiangjinwu modified the milestones: release-1.7, release-1.8 Mar 6, 2024
@xiangjinwu xiangjinwu modified the milestones: release-1.8, release-1.9 Apr 8, 2024
@xiangjinwu xiangjinwu modified the milestones: release-1.9, release-1.10 May 13, 2024
@xiangjinwu xiangjinwu modified the milestones: release-1.10, release-1.11 Jul 10, 2024
@xiangjinwu xiangjinwu modified the milestones: release-2.1, release-2.2 Oct 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant