XML Data Format NFe

0

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.

    
asked by anonymous 28.10.2015 / 20:12

1 answer

0

According to the NFe manual, the format of the date is:
AAAA-MM-DDThh:mm:ssTZD (UTC Universal Coordinated Time)

    
22.02.2016 / 02:22