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 vote97 views1 answer
Postgres reset auto increment
SQL
4 votes138 views1 answer
Delete record mysql query
SQL
1 vote168 views1 answer
Postgres install unaccent extension
SQL
3 votes230 views1 answer
Oracle show trigger code
SQL
1 vote153 views1 answer
Where to locate set password for mysql
SQL
0 vote193 views1 answer
T-sql delete view if exists
SQL
0 vote171 views1 answer
Oracle running queries
SQL
0 vote166 views1 answer
Ubuntu connect to mssql database
SQL
0 vote149 views1 answer
Sqlite referential integrity
SQL
11 votes145 views2 answers
Docker create postgres db
SQL