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 vote213 views1 answer
Remove transient options sql wordpress
SQL
9 votes228 views4 answers
Last mysql
SQL
3 votes221 views1 answer
Where id is in list sql
SQL
0 vote200 views2 answers
Postgresql get last day of month
SQL
0 vote235 views1 answer
Sql alter column name sql server
SQL
1 vote229 views1 answer
Mysql get latest duplicate rows
SQL
1 vote250 views1 answer
Mysql show long running queries
SQL
5 votes244 views1 answer
How to check port number for postgresql
SQL
0 vote201 views1 answer
Pgsql is not permitted to log in
SQL
1 vote213 views1 answer
Increase existing date in sql
SQL