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

56 votes296 views5 answers
Psql create user
SQL
1 vote120 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
3 votes123 views2 answers
How to force truncate a table in mysql
SQL
2 votes102 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote106 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote111 views1 answer
How to use sqlcommand
SQL
0 vote100 views1 answer
Mysql sql select one day before
SQL
-1 vote58 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote104 views1 answer
Oracle query archivemode
SQL
2 votes99 views2 answers
Join update query in sql
SQL