Mega Code Archive

 

Categories / MySQL / String

 

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>