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

0 vote196 views1 answer
Sql ignore
SQL
0 vote187 views1 answer
Pip install mysqlclient error
SQL
0 vote208 views1 answer
Replace sqlalchemy
SQL
3 votes188 views1 answer
Fk in insert mysql
SQL
0 vote192 views1 answer
Apex for oracle 11g
SQL
0 vote237 views1 answer
Mysql show foreign keys column
SQL
0 vote293 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote185 views1 answer
Mysql date time string format python
SQL
0 vote209 views1 answer
Select top values sql
SQL
2 votes253 views1 answer
Oracle block
SQL