Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

SELECT DATE_FORMAT(1999-01-01, %X %V)

mysql> mysql> SELECT DATE_FORMAT('1999-01-01', '%X %V'); +------------------------------------+ | DATE_FORMAT('1999-01-01', '%X %V') | +------------------------------------+ | 1998 52                            | +------------------------------------+ 1 row in set (0.00 sec) mysql>