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

3 votes358 views2 answers
Savepoint in sql
SQL
1 vote335 views1 answer
Mysql return if it contains
SQL
0 vote316 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote347 views1 answer
Transaction and commit trong sql server
SQL
-1 vote326 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote327 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
9 votes336 views3 answers
Date format in sql
SQL
0 vote365 views1 answer
Sql to excel pgadmin
SQL
0 vote310 views1 answer
Sql delete row from table where id
SQL
11 votes337 views5 answers
Update table from another table mysql
SQL