Question

1
Replies
240
Views
Close popover
Saurabh Kumar Singh (SaurabhKumarS)
Amazon

Amazon
IN
SaurabhKumarS Member since 2014 5 posts
Amazon
Posted: March 28, 2018
Last activity: April 16, 2018
Closed
Solved

Year Number, Month Number and Right Trim SQL functions not working on RD in Postgres

Hi Team

I have migrated from Oracle to Postgres DB and now the Year Number, Month Number and Right Trim SQL functions on my Report Definition have stopped working.

I noticed these function aliases are circumstanced with condition - pyProductType = ORACLE. Do we have any corresponding function aliases for Postgres.

Regards

Saurabh

***Updated by moderator: Lochan to add Categories***

Reporting
Moderation Team has archived post