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

Question

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- · Answer

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 · Answer

kindly provide suggestion on this PostgreSQL code .