ho provato con cdate e funziona

select id, data from (SELECT *, cdate(data_testo) as data FROM Tabella1 ) order by data