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 vote308 views1 answer
Sql view index
SQL
1 vote314 views1 answer
Oracle character set
SQL
0 vote328 views1 answer
How many rows affected in sqllite
SQL
5 votes306 views1 answer
Oracle ora-00054 causes
SQL
0 vote319 views1 answer
Mysql concat and use as where column
SQL
4 votes340 views2 answers
Tsql utf to local time
SQL
0 vote359 views1 answer
Disable database droping sql
SQL
0 vote356 views1 answer
Prisma transaction
SQL
3 votes342 views2 answers
How to open postgresql in windows
SQL
1 vote309 views1 answer
Set mysql mode global query
SQL