CODEWITHSUNDEEP
sql-servert-sqldatecomparison
TheTechGuy
TheTechGuy

Reputation: 17354

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

Both dates are stored in one table. If date1 is greater, I want to return date1, if date2 is greater I want to return date2. I want them to be part of larger query so I would like one main query but if that is not possible, I can use a temp table and use a second query afterward. The code will be executed in a stored procedure.

Upvotes: 6

Views: 27086

Answers (2)

Chris Cunningham
Chris Cunningham

Reputation: 1876

You could SELECT GREATEST('1776-07-04', '1977-08-16'). It should return the most recent date (not necessarily the best date).

Upvotes: 2

gbn
gbn

Reputation: 432311

It'll be a CASE statement in standard SQL

CASE WHEN date1 >= date2 THEN date1 ELSE date2 END

There are specific functions on some RDBMS that will do it like Excel does Max but this is standard...

Upvotes: 13

Related Questions