[C++][FlightRPC][ODBC] timestamp conversion from non-UTC to UTC
- Dominant language
- C++
- Stars
- 17.1k
- Forks
- 4.3k
- Avg merge
- 3d 13h
- Merged PRs (30d)
- 88
Description
### Describe the enhancement requested
the current behavior of ODBC is that it ignores the time zone field in Timestamp data, assumes all timestamp data is `UTC` during interpretation. The Arrow compute library should be able to handle converting non-UTC time zones to UTC, and that would require users to install the non-UTC time zone database on their machines (see https://github.com/apache/arrow/issues/47504). This GitHub issue is for finding a workaround that doesn't require user to install the time zone database on their machines manually.
- Possible solution: develop new function to interpret the Arrow timestamp seconds as the corresponding time zone, instead of using Arrow compute functions for this.
More on Arrow Timestamp type: https://arrow.apache.org/docs/cpp/api/datatype.html#_CPPv4N5arrow13TimestampTypeE
Parent issue: https://github.com/apache/arrow/issues/30622
### Component(s)
FlightRPC, C++
Contributor guide
Assessment
This issue has not been assessed yet.