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

An error may occur when reading the timestamptz type. #1176

Open
johnwiichang opened this issue Oct 23, 2024 · 0 comments · May be fixed by #1177
Open

An error may occur when reading the timestamptz type. #1176

johnwiichang opened this issue Oct 23, 2024 · 0 comments · May be fixed by #1177

Comments

@johnwiichang
Copy link

Encountered an issue in production: When using timestamptz to store time, during the execution of a SELECT query, performing Next() or Scan() operations on the sql.Rows object may report: expected end of input, got+00:00. After debugging the code, it was found that the data format might be "2022-11-16 05:49:05.517000 +00:00" or "2022-11-16 05:49:05 +00:00", meaning there may be a space before the timezone segment. In the database parameters, the DateStyle is confirmed to be ISO, YMD.

This issue was discovered on the TBase implementation of the PostgreSQL-like database.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
1 participant