Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Pavan Kumar Krovvidi (PavanK09) Wipro
Wipro
IN
PavanK09 Member since 2014 2 posts
Wipro
Posted: Jul 4, 2019
Last activity: Sep 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

To see attachments, please log in.
Data Integration

Posted: 5 years ago
Posted: 30 Sep 2019 12:09 EDT
Srinivas B Y (SrinivasB9086) Optum
Optum
IN

Hi,

Please check this link for more info regarding query runner.

An arithmetic operator cannot be used to compare date or datetime properties. 

You can use the following function to calculate time elapsed in minutes between two dates:

DATEDIFF(mi, start, end) hours_diff * 60 + DATE_PART('minute', end - start )

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice