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 votes139 views1 answer
Sql view column data type
SQL
1 vote184 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote202 views1 answer
Declarative base sqlalchemy
SQL
0 vote213 views1 answer
Connect to ssms with python
SQL
1 vote227 views1 answer
Epoch time converter in snowflake
SQL
2 votes219 views1 answer
Removing view
SQL
9 votes216 views1 answer
Alter table column change data type to text mysql
SQL
0 vote190 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote185 views1 answer
Like sql for second letter of the family name
SQL
3 votes291 views1 answer
How to get yesterday date in sql
SQL