Excel Extension format for 'dddd' (day of week name) maps sundays to the empty string #11319
Closed
Description
What happens?
When the excel format functions are used (as part of the excel extension) the day of week name formatter dddd
seems to not map Sundays properly, instead mapping them to the empty String.
To Reproduce
> SELECT excel_text(i.generate_series, 'dddd') FROM generate_series(0, 14) as i;
┌───────────────────────────────────────┐
│ excel_text(i.generate_series, 'dddd') │
│ varchar │
├───────────────────────────────────────┤
│ Saturday │
│ │
│ Monday │
│ Tuesday │
│ Wednesday │
│ Thursday │
│ Friday │
│ Saturday │
│ │
│ Monday │
│ Tuesday │
│ Wednesday │
│ Thursday │
│ Friday │
│ Saturday │
├───────────────────────────────────────┤
│ 15 rows │
└───────────────────────────────────────┘
OS:
mac
DuckDB Version:
0.10.1, 0.9.2
DuckDB Client:
shell, cli, wasm
Full Name:
Jonathan Swenson
Affiliation:
Omni
Have you tried this on the latest nightly build?
I have tested with a release build (and could not test with a nightly build)
Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?
- Yes, I have
Activity
Fix duckdb#11319: use modulo when computing day of the week in excel …
Merge pull request #11328 from Mytherin/issue11319
Mytherin commentedon Mar 24, 2024
Thanks for the report! Fix is up here - #11328