1
77%
BABEL_5_X_DEV: 77%

Ran 01 Jul 2025 10:10PM UTC

Files 120

Run time 5s

Badge

Embed ▾

Committed 01 Jul 2025 09:34PM UTC coverage: 75.867%. Remained the same

Job # 16010651505.1

Build Type

push

github

Committed by

web-flow

Commit Message

Fix for DATENAME() gives incorrect value with TZOFFSET part (#3846)


Currently, DATENAME function returns a numeric value for TZOFFSET
datepart, which does not match SQL Server's text output.

Root cause: The function definition of sys.datename explicitly calls the
DATEPART function for most argument values, including TZOFFSET, thereby
returning a numerical offset value instead of the required text format
(+/-HH:MM).

Fix: Modified the sys function's SQL definition to extract and return
the timezone offset substring from the input - similar to how the
offset_string is determined in DATETRUNC/DATEBUCKET - if the argument
matches tzoffset. Furthermore, translated the function from SQL language
to plpgsql in order to enable raising an exception for unsupported input
datetime datatypes such as date, time, datetime and smalldatetime.

Task: BABEL-5846
Signed-off-by: Manisha Deshpande <mmdeshp@amazon.com>

Run Details

49470 of 65206 relevant lines covered (75.87%)

315744.79 hits per line

babelfish-for-postgresql / babelfish_extensions / 16010651505 / 1
77%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 16010651505.1

babelfish-for-postgresql / babelfish_extensions / 16010651505 / 1 77% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 16010651505.1

babelfish-for-postgresql / babelfish_extensions / 16010651505 / 1
77%
BABEL_5_X_DEV: 77%

README BADGES
x