babelfish-for-postgresql / babelfish_extensions / 12366035710

76%

BABEL_5_X_DEV: 77%

push

github

Fix Datapart functions to be Timezone Invariant (#3253)

We were incorrectly passing timezone to timestamp2tm function which would cause the datepart functions to be timezone dependent , If we pass tzp by reference to timestamp2tm function, then internally localtime converts the given original timestamp value to date and time values adding timezone offset taking GMT as a reference timezone. However, if NULL is passed instead then we keep the original timestamp intact and that's what actually PG does.

Cherry pick #3226

Issues Resolved
BABEL-5453

Signed-off-by: Nirmit Shah nirmisha@amazon.com

1 of 1 new or added line in 1 file covered. (100.0%)

46604 of 62277 relevant lines covered (74.83%)

164750.37 hits per line