Nfe Data XML Format

Asked

Viewed 482 times

-1

I am trying to insert a date into an oracle PL-SQL table.

I search the date when reading the XML of an Nfe, but the tag appears this way <dhEmi>2015-10-02T14:49:52-04:00</dhEmi> I did some research on the internet and saw that the format is this yyyy-MM-ddTHH:mm:ss-SSSS set being the set -SSSS the local time zone.

Despite the researches I did, I didn’t understand how I convert this date directly in Visual Studio to a format that Oracle accepted, ie the format yyyy-MM-dd HH24:mi:ss.

I tried to_date and to_char, but both did not work, still returning invalid input format.

xml vb.net pl-sql nfe
  • 1

    According to the Nfe manual, the date format is: AAAA-MM-DDThh:mm:ssTZD (UTC &#xA;Universal Coordinated Time)

  • 1

    Thank you for the information !

1 answer

0

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

Browser other questions tagged xml vb.net pl-sql nfe

You are not signed in. Login or sign up in order to post.