Question

1
Replies
202
Views
X
SaurabhKumarS Member since 2014 5 posts
Amazon
Posted: 2 years ago
Last activity: 2 years 3 months ago
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
Share this page LinkedIn