[Bug]: DAY,MONTH,YEAR function cannot accept TEXT parameter

[Teletele-Lin]

What happened?

DAY,MONTH,YEAR function cannot accept TEXT parameter:

SELECT DAY('2015-04-30 01:01:01.1234567');
SELECT MONTH('2015-04-30 01:01:01.1234567');
SELECT YEAR('2015-04-30 01:01:01.1234567');

The TEXT parameter type is not overloaded, function definition:

CREATE OR REPLACE FUNCTION sys.day(date ANYELEMENT)
RETURNS INTEGER AS
$BODY$
SELECT sys.datepart('day', date);
$BODY$
STRICT
LANGUAGE SQL IMMUTABLE;

CREATE OR REPLACE FUNCTION sys.month(date ANYELEMENT)
RETURNS INTEGER AS
$BODY$
SELECT sys.datepart('month', date);
$BODY$
STRICT
LANGUAGE SQL IMMUTABLE;

CREATE OR REPLACE FUNCTION sys.year(date ANYELEMENT)
RETURNS INTEGER AS
$BODY$
SELECT sys.datepart('year', date);
$BODY$
STRICT
LANGUAGE SQL IMMUTABLE;

Version

BABEL_5_X_DEV (Default)

Extension

babelfishpg_tsql (Default)

Which flavor of Linux are you using when you see the bug?

Ubuntu (Default)

Relevant log output

could not determine polymorphic type because input has type unknown

Code of Conduct

• I agree to follow this project's Code of Conduct.

[tanscorpio7]

Thanks for reporting this, tracking this under BABEL-5847.

An explicit cast on top of the argument can be used as a temporary workaround.

SELECT DAY(CAST('2015-04-30 01:01:01.1234567' AS VARCHAR));