Oracle -- cast

cast进行数据类型的转换。如

SELECT CAST(TO_DATE('20180227114223','YYYY-MM-DD HH24:MI:SS') AS DATE) N1 FROM DUAL;--2018/2/27 11:42:23
SELECT SYSDATE,CAST(SYSDATE AS TIMESTAMP WITH LOCAL TIME ZONE ) N2 FROM DUAL;--sysdate:2018/2/27 11:42:54,N2：27-2月 -18 11.42.54.000000 上午
SELECT CAST('weyowieo' AS CHAR(6)) N3 FROM DUAL; --2323