How to return "YES"/"NO" based on date comparison in SQL

Question

Aryan Kumar · Answer

To return "YES" or "NO" based on date comparison in SQL, you can use a CASE statement with the DATEDIFF function to compare the two dates.

Here's an example query:

SELECT CASE
        WHEN DATEDIFF(day, date1, date2) > 30 THEN 'YES'
        ELSE 'NO'
      END AS result
FROM student;

In this example, date1 and date2 are the two dates you want to compare, and student is the table where the dates are stored.

The DATEDIFF function calculates the difference between two dates in a specified unit (in this case, days). If the difference between the two dates is greater than 30 days, the query will return 'YES', otherwise it will return 'NO'.

You can adjust the comparison to suit your needs, such as comparing months, years, or even hours or minutes.

Krishnapriya Rajeev · Answer

A CASE statement is used to return "YES" or "NO" based on a date comparison in SQL. An example is demonstrated below:

SELECT
  CASE
    WHEN date1 > date2 THEN 'YES'
    ELSE 'NO'
  END AS result
FROM your_table;

date1 and date2 are the columns that require comparison in a table in the above example. The CASE statement checks whether date1 is greater than date2 and produces a result of YES if it is true, and NO otherwise.

forum

How to return "YES"/"NO" based on date comparison in SQL

Can you answer this question?

2 Answers