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