oracle 获取一个字段的年月日

to_date(to_char(extract (year from a.field0127)) || '-'|| to_char(extract (month from a.field0127)) || '-'||  to_char(extract (day from a.field0127)),'yyyy-mm-dd hh24:mi:ss')