Sql get latest of 2 datetimes

SELECT ID,
       CASE WHEN 
              COALESCE(Date1, '1/1/1973') > COALESCE(Date2, '1/1/1973') -- COALESCE is to ensure comparison works when 1 is nullable
         THEN Date1
         ELSE Date2
       END AS MostRecentDate
FROM Table

Source: stackoverflow.com

Similar codes

1 vote185 views1 answer
Mysql check table exists
SQL
0 vote194 views1 answer
Default order by in mysql
SQL
0 vote218 views1 answer
Sort by
SQL
0 vote182 views1 answer
Uuid sqlalcomany
SQL
0 vote187 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote215 views1 answer
Delete a record from a table sqlite3
SQL
0 vote352 views1 answer
Oracle sql alter view add column
SQL
10 votes178 views2 answers
Linux command line import mysql database
SQL
0 vote181 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
13 votes183 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL