ERROR: operator does not exist: timestamp without time zone - bigint.- ( a.DURATION

[anirbansengupta]

AND ( a.END_DATE_TIME >=
b.END_DATE_TIME
- ( a.DURATION
+ (SELECT DISTINCT TIME_ADJ_MINS * 60
FROM TYPE_PARAM
WHERE CARRIER = a.CARRIER))

[Nic Brough -Adaptavist-]

You can't run SQL against Cloud Confluence, so I'm guessing you've hit the wrong tag there.

This does not look like a Confluence database, and even if it were, you should not be using SQL to do anything with it.

Could you explain what this has to do with Confluence (or any Atlassian system), and what you're actually trying to achieve?

[anirbansengupta]

kindly provide suggestion on this PostgreSQL code .