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

17 votes311 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote278 views1 answer
Sql delete caracter list
SQL
0 vote257 views2 answers
How to start postgresql laravel
SQL
0 vote271 views1 answer
How to add boolean column in postgresql
SQL
1 vote268 views2 answers
Sql queries practice
SQL
1 vote251 views1 answer
Display total number of tables in mysql
SQL
1 vote271 views1 answer
Mysql show database size in mb
SQL
1 vote267 views2 answers
Sql now - 1 day
SQL
6 votes272 views2 answers
What is non relational database
SQL
0 vote254 views1 answer
Default value false mysql
SQL