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

2 votes312 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
1 vote243 views2 answers
Show sql logs in spring boot
SQL
0 vote305 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote291 views1 answer
Where date in datetime mysql
SQL
0 vote288 views1 answer
Postgres execute multiple sql file from command line
SQL
1 vote279 views1 answer
User privileges postgresql information_schema
SQL
5 votes273 views2 answers
Ranking functions in sql
SQL
0 vote302 views1 answer
Oracle running queries
SQL
0 vote279 views1 answer
Sql find table by name
SQL
0 vote286 views1 answer
Postgresql delete multiple rows
SQL