date类型转Char
TO_CHAR(DATE,'YYYY-MM-DD') AS XXX
TO_CHAR(DATE,'YYYY-MM-DD HH24:MI:SS') AS XXX,
Char类型转date
TO_DATE('CHAR','YY-MM-DD')
date类型转Char
TO_CHAR(DATE,'YYYY-MM-DD') AS XXX
TO_CHAR(DATE,'YYYY-MM-DD HH24:MI:SS') AS XXX,
Char类型转date
TO_DATE('CHAR','YY-MM-DD')