Re: [firebird-support] Re: Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)

[sboyd...@gmail.com [firebird-support]]

> Assuming OPS_ONBOARD_TIME, OPS_DELIVERED_TIME and OPS_APPT_LOW are all DATE 
> type,does this solve that problem?

> COALESCE(OPS_ONBOARD_TIME, OPS_DELIVERED_TIME, OPS_APPT_LOW, CURRENT_DATE)
 

 Since they are all TIMESTAMPS, that didn't fix the problem but 
CURRENT_TIMESTAMP did.
 

 Thanks.