Question

2
Replies
703
Views
PavanK09 Member since 2014 2 posts
Wipro
Posted: July 4, 2019
Last activity: September 30, 2019
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
Share this page LinkedIn