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')
