Convert NVARCHAR to DATE Format DD/MM/YYYY

When trying to convert a field from NVARCHAR to DATE, the following error appears:

Could not execute 'SELECT TO_CHAR(TO_DATE("FECHA", 'MM/DD/YYYY'), 'MM/DD/YYYY') FROM "@A11_HISTO_VTA"' in 30 ms 188 µs . [314]: numeric overflow: search table error: [6944] AttributeEngine: overflow in numeric calculation;string format(daydate [here]daydate(string "FECHA", string 'MM/DD/YYYY'), string 'MM/DD/YYYY'),FECHA = '24/11/2017'[string]; checkNull false

Use the following SQL commands to perform the operation:

- SELECT TO_CHAR(TO_DATE("FECHA", 'MM/DD/YYYY'), 'MM/DD/YYYY') FROM "@A11_HISTO_VTA"
- SELECT TO_DATE ("FECHA",'MM/DD/YYYY') FROM "@A11_HISTO_VTA"
- SELECT TO_VARCHAR(TO_DATE(FECHA, 'YYYYMMDD'), 'YYYY-MM-DD') FROM "@A11_HISTO_VTA"