SELECT RIGHT('1995-03-01',5), RIGHT('1996-02-29',5); : RIGHT « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. RIGHT

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>








Related examples in the same category

1.RIGHT(, )
2.Return just the MM-DD component of the date with RIGHT()
3.The following comparison produces a result that is correct in lexical terms but incorrect in temporal terms