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.