| Subject | Re: [firebird-support] Re: Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause) |
|---|---|
| Author | |
| Post date | 2015-05-07T20:54:40Z |
SET;
That's slick. I'm going to have to read up on the WITH command.
Had to change the coalesce with all the dates to cast each date individually or I got a conversion error. Not sure why.
COALESCE(CAST(OPS_ONBOARD_TIME AS DATE), CAST(OPS_DELIVERED_TIME AS DATE), CAST(OPS_APPT_LOW AS DATE), CAST('TODAY' AS DATE)),