使用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 dualselect to_date('-01-19 11:32:02','yyyy-mm-dd hh24:mi:ss') from dual
/weixin_39629188/article/details/111494617