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 vote143 views2 answers
Sql join on comma separated field
SQL
0 vote144 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote145 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
13 votes291 views4 answers
Sql joining 3 tables
SQL
2 votes149 views1 answer
Pdo mysql insert
SQL
1 vote145 views1 answer
Oracle convert run duration to number
SQL
0 vote137 views1 answer
Run mssql server terminal
SQL
1 vote187 views1 answer
Select last row from SQL Table
SQL
0 vote150 views1 answer
Guid string to binary better
SQL
10 votes157 views1 answer
How to import database in mysql by cmd
SQL