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 vote136 views1 answer
Min and max salary and name in sql
SQL
0 vote140 views1 answer
Contact mysql column field
SQL
1 vote134 views1 answer
How to find median of a column sql
SQL
15 votes308 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote159 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
7 votes135 views4 answers
Lowest salary in sql
SQL
31 votes149 views2 answers
Grant all priviledges to mysql user
SQL
1 vote128 views1 answer
Import local sql into remote mysql
SQL
0 vote144 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
4 votes102 views1 answer
Oracle sleep
SQL