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

4 votes190 views1 answer
SQL find text in SP
SQL
0 vote367 views1 answer
Multiple row join
SQL
0 vote200 views3 answers
Postgres date difference seconds
SQL
0 vote284 views1 answer
Bigrock database connection string
SQL
2 votes171 views1 answer
How to delete columns in sql
SQL
0 vote191 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
1 vote222 views1 answer
Does insert into overwrite sql
SQL
1 vote238 views2 answers
Mysql limit offset
SQL
0 vote185 views1 answer
Mysql workbench indent formatting
SQL
0 vote251 views1 answer
Sqlite update where exists
SQL