elastic / elastic/elasticsearch-sql-odbc

Provide timezone in the IANA specification

Open
#329 0 comments 0 reactions 0 assignees View on GitHub
>feature
Dominant language
C
Stars
18
Forks
33
Avg merge
1d 16h
Merged PRs (30d)
4

Description

The driver will detect system's set time zone (or that set through an environment variable) and provide that to Elasticsearch in the ISO 8601 UTC offset format `±[hh]:[mm]`. This however doesn't convey DST rules that should be applied on the server when processing dates. This is particularity relevant for the [date histogram agg](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-datehistogram-aggregation.html), used by SQL's [HISTOGRAM](https://www.elastic.co/guide/en/elasticsearch/reference/master/sql-functions-grouping.html#sql-functions-grouping-histogram) grouping function.

This issue is to enhance driver's functionality to allow the timezones be specified using the IANA format, which convey the DST rules to apply based on a timestamp's value.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.