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 vote364 views1 answer
Sql values that contains certain multiple ids
SQL
2 votes345 views2 answers
Get all tables using like
SQL
0 vote345 views1 answer
Sql delete caracter list
SQL
0 vote353 views1 answer
Mysql reset wp_options
SQL
0 vote334 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote306 views1 answer
Provera dupliranih konatakata
SQL
0 vote309 views1 answer
Sql auto_increment syntax
SQL
5 votes353 views4 answers
Traduction
SQL
0 vote315 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote319 views1 answer
Which lock mode is not available in sql
SQL