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 vote258 views1 answer
Sql server cannot create database diagram
SQL
150 votes477 views10 answers
Grepper
SQL
15 votes258 views2 answers
Open postgress in terminal mac
SQL
0 vote266 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote260 views1 answer
Increase speed of like queries postgres
SQL
0 vote252 views3 answers
Get count of null in column sql
SQL
2 votes293 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote304 views2 answers
Postgres isnull
SQL
0 vote286 views1 answer
Mysql trigger to delete old data
SQL
0 vote269 views2 answers
Disadvantages of stored procedures sql
SQL