Both dates are stored in one table. If date1 is greater, I want to return date1, if date2 is greater I want to return date2. I want them to be part of larger query so I would like one main query but if that is not possible, I can use a temp table and use a second query afterward. The code will be executed in a stored procedure.
It'll be a CASE statement in standard SQL
CASE WHEN date1 >= date2 THEN date1 ELSE date2 END
There are specific functions on some RDBMS that will do it like Excel does Max but this is standard...
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With