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 vote356 views1 answer
Influxdb list all tags for a measurement
SQL
25 votes325 views5 answers
Uninstall mysql ubuntu
SQL
-1 vote337 views1 answer
Spring boot mysql connection properties
SQL
0 vote322 views2 answers
Sql 2 way of select unique
SQL
0 vote338 views1 answer
Creation d'un trigger sql
SQL
4 votes316 views1 answer
Mysql ip address
SQL
12 votes326 views1 answer
Script to add new column in table sql
SQL
0 vote350 views1 answer
Nvl2 syntax
SQL
0 vote349 views2 answers
How to prevent sql injection in java
SQL
0 vote336 views1 answer
Ver usuarios mysql
SQL