Answers for "find latest two datetime values sql"

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

Posted by: Guest on February-18-2021

Source

Code answers related to "find latest two datetime values sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "find latest two datetime values sql"

Code answers related to "find latest two datetime values sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "find latest two datetime values sql"

Code answers related to "find latest two datetime values sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us