mysql date_format now code example

Example: mysql now format

SELECT DATE_FORMAT(NOW(),'%Y-%m-%d %H-%i-%s')