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

1 vote308 views1 answer
Sql into vs insert into
SQL
0 vote379 views1 answer
Trigger
SQL
0 vote301 views1 answer
Php delete database
SQL
2 votes302 views3 answers
Current month mysql query
SQL
0 vote338 views1 answer
Mysql grant all on all databases
SQL
6 votes304 views2 answers
Clear a table in mysql
SQL
0 vote298 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote308 views1 answer
MySQL import data from large CSV file
SQL
0 vote326 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
-2 votes295 views3 answers
Sqlite reset autoincrement
SQL