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 vote232 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote213 views1 answer
Oracle DROP PROGRAM
SQL
3 votes218 views2 answers
Sqlite print all column names
SQL
7 votes205 views3 answers
Add primary key to database sql
SQL
3 votes228 views2 answers
Truncate all tables
SQL
1 vote214 views1 answer
Oracle update with sequence
SQL
12 votes223 views1 answer
Script to add new column in table sql
SQL
0 vote246 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote213 views1 answer
Postgresql select fast check no rows
SQL
0 vote218 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL