Question

2
Replies
778
Views
Pavan Kumar Krovvidi (PavanK09)
Wipro

Wipro
IN
PavanK09 Member since 2014 2 posts
Wipro
Posted: July 4, 2019
Last activity: September 30, 2019
Posted: 4 Jul 2019 6:54 EDT
Last activity: 30 Sep 2019 12:09 EDT
Closed

Regarding query runner in Pega 8.1

​Hi All,

Does anybody know about what syntax is allowed in 'Query Runner' in 8.1 Environment ? Especially I am checking for a date difference in minutes. The ​Postgresql help documents says the minus (-) operator can be used as syntax for the difference of dates in Postgresql; but that couldn't help i.e, the minus operator is not getting considered as operator.

As well as, when we want to perform arthimetic operations on data which doesn't belong to any TABLE; we use the keyword DUAL(in Oracle SQL) such as in:

'select DATEX-DATEY from dual;'

Any way to do computations in 'Query Runner' as well similar to above ?

If any body knows the above, could you please help me with the same.

Regards,

Pavan

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.