I'm trying to insert a date into an Oracle PL-SQL table.
I look for the date when reading the XML of an NFe, however the tag appears like this <dhEmi>2015-10-02T14:49:52-04:00</dhEmi>
I did some searches on the internet and I saw that the format is this yyyy-MM-ddTHH: mm: ss-SSSS being the set -SSSS the local time zone.
I tried to_date and to_char, but both did not work, it continues to return invalid input format.