Mysql-date_format()各参数实例

1."%Y/%M/%D"

select date_format("2021/9/1 22:11:12","%Y/%M/%D") from dual

输出：2021/September/1st

2."%y/%m/%d"

select date_format("2021/9/1 22:11:12","%y/%m/%d") from dual

输出：21/09/01

3."%H:%i:%s"

select date_format("2021/9/1 22:11:12","%H:%i:%s") from dual#24小时制

输出：22:11:12
4."%h:%i:%s"

select date_format("2021/9/1 22:11:12","%h:%i:%s") from dual

输出：10:11:12