Compare two dates in a table and return the greater using SQL Server

Compare two dates in a table and return the greater using SQL Server

We can get and return using CASE statement in SQL Server. i.e.

CASE
   WHEN STARTDATE >= ENDDATE
       THEN STARTDATE
   ELSE ENDDATE

END


The example in detail as given below.


SELECT
            EXCEPTIONID,
            (CASE
               WHEN INSERTEDDATE >= UPDATEDDATE
                           THEN INSERTEDDATE
               ELSE UPDATEDDATE
            END) AS EXCEPTION_DATE

FROM [DBO].[APPEXCEPTION]


ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
My Blogs - https://code-sample.com and https://code-sample.xyz
My Book1 - BEST SELLING ANGULAR BOOK (INCLUDING ALL VERSIONS 2, 4, 5, 6, 7)
My Book2 - ANGULAR 2 INTERVIEW QUESTIONS BOOK - Both Books are Available on WorldWide.

www.code-sample.com/. Powered by Blogger.