Mysql case when on date

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;

Source: stackoverflow.com

Similar codes

1 vote159 views1 answer
Sql set auto increment back to 0
SQL
4 votes149 views1 answer
T-sql get duplicate rows
SQL
0 vote137 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
2 votes136 views1 answer
Find all triggers in database
SQL
4 votes134 views3 answers
Mysql update with join
SQL
0 vote172 views1 answer
Mysql extract day from date leading zero
SQL
4 votes241 views6 answers
Laravel jwt
SQL
0 vote148 views1 answer
Limit in access query
SQL
0 vote130 views2 answers
Postgresql change user role grant
SQL
10 votes134 views1 answer
Oracle view dependencies
SQL