String MySQL

  1. Home
  2. MySQL
  3. String
  4. SELECT RIGHT(1995-03-01,5), RIGHT(1996-02-29,5)
mysql>
mysql> SELECT RIGHT('1995-03-01',5), RIGHT('1996-02-29',5);
+-----------------------+-----------------------+
| RIGHT('1995-03-01',5) | RIGHT('1996-02-29',5) |
+-----------------------+-----------------------+
| 03-01                 | 02-29                 |
+-----------------------+-----------------------+
1 row in set (0.00 sec)
mysql>
mysql>