Fix UTC+HHMM time zone was parsed incorrectly by tianjq16 · Pull Request #22297 · duckdb/duckdb · GitHub
Skip to content

Fix UTC+HHMM time zone was parsed incorrectly - #22297

Merged
Mytherin merged 1 commit into
duckdb:v1.5-variegatafrom
tianjq16:bugfix_utc_time_zone_parsed_incorrectly
Apr 28, 2026
Merged

Mytherin merged 1 commit into
duckdb:v1.5-variegatafrom
tianjq16:bugfix_utc_time_zone_parsed_incorrectly

Conversation

@tianjq16

Copy link
Copy Markdown
Contributor

The parsing of UTC+HHMM exhibits an issue regarding the handling of zeros, which can lead to incorrect parsing.

For example:

D set timezone='UTC+10:00';
D select * from duckdb_settings() where name like '%Zone%';
┌──────────┬───────────┬───────────────────────┬────────────┬─────────┬───────────┐
│   name   │   value   │      description      │ input_type │  scope  │  aliases  │
│ varchar  │  varchar  │        varchar        │  varchar   │ varchar │ varchar[] │
├──────────┼───────────┼───────────────────────┼────────────┼─────────┼───────────┤
│ TimeZone │ Etc/GMT-1 │ The current time zone │ VARCHAR    │ LOCAL   │ []        │
└──────────┴───────────┴───────────────────────┴────────────┴─────────┴───────────┘

@Mytherin
Mytherin merged commit 2f6fa1c into duckdb:v1.5-variegata Apr 28, 2026
64 checks passed
@Mytherin

Copy link
Copy Markdown
Member

kaka11chen pushed a commit to kaka11chen/astrovela_vane that referenced this pull request Aug 14, 2026
The parsing of UTC+HHMM exhibits an issue regarding the handling of
zeros, which can lead to incorrect parsing.

For example:

```
D set timezone='UTC+10:00';
D select * from duckdb_settings() where name like '%Zone%';
┌──────────┬───────────┬───────────────────────┬────────────┬─────────┬───────────┐
│   name   │   value   │      description      │ input_type │  scope  │  aliases  │
│ varchar  │  varchar  │        varchar        │  varchar   │ varchar │ varchar[] │
├──────────┼───────────┼───────────────────────┼────────────┼─────────┼───────────┤
│ TimeZone │ Etc/GMT-1 │ The current time zone │ VARCHAR    │ LOCAL   │ []        │
└──────────┴───────────┴───────────────────────┴────────────┴─────────┴───────────┘
```

Upstream-Commit: duckdb/duckdb@2f6fa1c
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants