oracle将日期格式化to_char及字符串转日期to_date

使用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