select
to_char(
cast
(
cast
(
'21-4月 -17 04.13.02.000000000 下午'
as
timestamp
)
as
date
),
'yyyy-mm-dd hh24:mi:ss'
)
from
dual;
to_char(
cast
(
cast
(
'21-4月 -17 04.13.02.000000000 下午'
as
timestamp
)
as
date
),
'yyyy-mm-dd hh24:mi:ss'
)
from
dual;