apache / apache/arrow

[C++][FlightRPC][ODBC] timestamp conversion from non-UTC to UTC

Open
#47,631 0 comments 0 reactions 0 assignees View on GitHub
Component: C++ Component: FlightRPC Type: enhancement
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.