Mega Code Archive

 
Categories / MySQL Tutorial / Date Time Functions
 

SELECT LAST_DAY(2004-01-01 01

mysql> mysql> SELECT LAST_DAY('2004-01-01 01:01:01'); +---------------------------------+ | LAST_DAY('2004-01-01 01:01:01') | +---------------------------------+ | 2004-01-31                      | +---------------------------------+ 1 row in set (0.00 sec) mysql>