Can TZCONVERTOR push down to SQL or Oracle data source

[Mihaela Oncel]

Hi,

I am trying to convert UTC in Atlantic Time::

Example:

TZCONVERTOR ( TIMESTAMP '2023-02-20 19:30:00', 'UTC', 'Canada/Atlantic') createdOnLocal

but it does not push down to SQL or Oracle.

Is there any way to push that down to the data source?

Thanks,

Mihaela

[Mihaela Oncel]

Execution Plan:

Cannot push selectable because the data source SqlServer does not support the function --TZCONVERTOR(request.createdOn, 'UTC', 'Canada/Atlantic')-- Cannot push selectable because the data source SqlServer does not support the function --TZCONVERTOR(request.solvedOn, 'UTC', 'Canada/Atlantic')-- Cannot push selectable because the data source SqlServer does not support the function --TZCONVERTOR(request.slaExpectedFixBreach, 'UTC', 'Canada/Atlantic')--