how to format now function in mysql code example

Example: mysql now format

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