Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

GET_FORMAT(DATETIME,JIS)

mysql> mysql> select GET_FORMAT(DATETIME,'JIS'); +----------------------------+ | GET_FORMAT(DATETIME,'JIS') | +----------------------------+ | %Y-%m-%d %H:%i:%s          | +----------------------------+ 1 row in set (0.00 sec) mysql>