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

1 vote230 views1 answer
Oracle previous year
SQL
0 vote167 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote173 views1 answer
Mssql disable foreign key constraint
SQL
4 votes169 views1 answer
Oracle delete last row
SQL
17 votes225 views6 answers
Get last record in sql
SQL
0 vote174 views1 answer
Kotlin sqlite delete row
SQL
0 vote166 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
3 votes261 views2 answers
Savepoint in sql
SQL
0 vote215 views1 answer
Drop a view in sqlite
SQL
0 vote176 views1 answer
Mysql replication change database name
SQL