Check out example codes for "mysql case when on date". It will help you in understanding the concepts better.

Code Example 1

SELECT
  id,
  CASE
    WHEN date_activated > '2011-11-23 18:30:00' THEN 'after'
    WHEN date_activated > '2010-01-20 00:00:00' THEN 'before'
    ELSE 'not yet'
  END AS date_note
FROM table1;

Learn ReactJs, React Native from akashmittal.com