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

0 vote179 views1 answer
Capabilities of sql select statements
SQL
0 vote142 views1 answer
Mysql get date diff in months
SQL
4 votes141 views2 answers
Oracle sql group by date year
SQL
1 vote129 views1 answer
Too many connections mysql
SQL
0 vote160 views2 answers
While mysql
SQL
0 vote153 views1 answer
How convert into in in sql query
SQL
0 vote126 views1 answer
Strat with in sql
SQL
0 vote132 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote143 views1 answer
Shell script to log mysql cpu usage
SQL
3 votes143 views3 answers
Mysql order by list
SQL