- 使用to_char()
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') time from dual;
select to_char(sysdate,'yyyy"年"mm"月"dd"日"') time from dual;
- 使用todate()
select sysdate from dual
select to_date('2011-01-19 11:32:02','yyyy-mm-dd hh24:mi:ss') from dual
https://blog.csdn.net/weixin_39629188/article/details/111494617