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

2 votes392 views2 answers
Create table mysql integer NOT null
SQL
0 vote347 views1 answer
Commit transaction sql
SQL
11 votes360 views2 answers
Insert date sql
SQL
3 votes412 views2 answers
See mysql users ubuntu
SQL
6 votes349 views1 answer
Wordpress change user password sql
SQL
0 vote370 views1 answer
Oracle sql copy table without data
SQL
7 votes365 views1 answer
Alter sequence set current value oracle
SQL
0 vote336 views1 answer
Wordpress sql change site url
SQL
0 vote352 views1 answer
Case when with count and combining similar values in sql
SQL
9 votes331 views1 answer
Identity insert on sql server
SQL