16010651505
77%

Ran 01 Jul 2025 10:10PM UTC

Jobs 1

Files 120

Run time 1min

Badge

Embed ▾

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

Build # 16010651505

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

Jobs

ID	Job ID	Ran	Files	Coverage
1	16010651505.1	01 Jul 2025 10:10PM UTC	120	75.87	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 16010651505
77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 16010651505

babelfish-for-postgresql / babelfish_extensions / 16010651505 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 16010651505

babelfish-for-postgresql / babelfish_extensions / 16010651505
77%

README BADGES
x