See if this works.
On a session level set the timezone to your local daylight saving timezone:
SET TIME ZONE 'America Brazil';
and then remove the '-00:00' and cast like this:
CAST(SUBSTRING(col FROM 1 FOR 26) AS TIMESTAMP) AT LOCAL