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 vote211 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
1 vote222 views1 answer
Sql comment header
SQL
0 vote235 views1 answer
Grepper sql workbench download
SQL
4 votes251 views2 answers
Mysql alter table set column unique
SQL
0 vote221 views1 answer
Get duplicate entry sql
SQL
0 vote237 views1 answer
Select last N rows mysql
SQL
0 vote238 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote219 views1 answer
Output to file mysql
SQL
10 votes237 views1 answer
Oracle dba_dependencies
SQL
0 vote254 views1 answer
Sqlite löschen einer tabelle
SQL