Understanding ISO / UTC Date Format Extracted From Files (Doc ID 2212200.1)

Last updated on AUGUST 14, 2023

Applies to:

Goal

A customer uses Outside In to extract metadata from PDF files.  They need to know how to get the times extracted for PDF files to UTC.  As an example, a PDF file produced the following dates and times in the extracted output:

Creation Date = D:20151007163052+00'00'
Revision Date = D:20151027105033+09'00'

Since the Creation Date = D:20151007163052+00'00', they assume that this date/time is in UTC as it says +00'00'. Since the goal is to get all dates/times into UTC, they would not change this value at all, as it is all ready in UTC.  Is this correct?  Also, since the Revision Date = D:20151027105033+09'00', they assume that this PDF file was last revised in GMT+9. In this case, they would add or subtract 9 hours?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.