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 vote185 views1 answer
How to give access to database in postgresql server to another user
SQL
4 votes149 views1 answer
Check database name postgresql
SQL
0 vote167 views1 answer
Tsql pad left
SQL
0 vote143 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote167 views1 answer
Postgres - Login and connect as default user
SQL
0 vote155 views1 answer
Oracle service name view
SQL
-1 vote139 views3 answers
Mysql get age from date
SQL
0 vote191 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote164 views1 answer
Mysql grouping functions
SQL
1 vote151 views1 answer
How to update date add hours in postgresql
SQL