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 vote179 views3 answers
Run sql command line
SQL
3 votes180 views1 answer
Select sequence oracle
SQL
0 vote184 views1 answer
How to check database engine in mysql
SQL
0 vote186 views1 answer
Limit in access query
SQL
0 vote120 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
2 votes168 views1 answer
How to make insert script from table in SQL server
SQL
1 vote176 views2 answers
Mysql show views
SQL
18 votes171 views4 answers
Mysql current date between two dates
SQL
0 vote177 views2 answers
Collation in sql
SQL
0 vote183 views1 answer
Get record which is available in one table but not in another mysql
SQL