From string to number and date

SQL++
1

Hi I have this field “NATIONALID”: “966 134 054” and I well have it converted to number like 966134054 without the spaces.
And I also have a date like “@DATE”: “2013-10-28” that I well have to date object.

I have tryed the tonumbers, but it remove everything.

2 
SELECT TO_NUMBER(REPLACE(d.NATIONALID, " ", "")) AS num,
       DATE_FORMAT_STR(d.`@DATE`, "1111-11-11T00:00:00+00:00") AS date
FROM {"NATIONALID": "966 134 054" , "@DATE": "2013-10-28"} AS d;