About Date and Timestamp Formatting for CSV File-based Extractors
Extractors such as Secure FTP (SFTP), Amazon Simple Storage Service (AWS S3), and Oracle Object Storage Service use CSV data files that have date and timestamp fields.
For the CSV file-based extractors, use the format examples to provide the
values in the CSV Date Format, and CSV Timestamp Format fields while entering the source
connection details.
Note:
Ensure that the date and timestamp formats for the data files match the date and timestamp formats in your source; for example, if you've used MM/dd/yyyy and MM/dd/yyyy hh:mm:ss in your source, then you must specify the same formats while creating the applicable data connections.Examples
| Example | Pattern |
|---|---|
| 1/23/1998 | MM/dd/yyyy |
| 1/23/1998 12:00:20 | MM/dd/yyyy hh:mm:ss |
| 12:08 PM | h:mm a |
| 01-Jan-1998 | dd-MMM-yyyy |
| 2001-07-04T12:08:56.235-0700 | yyyy-MM-dd'T'HH:mm:ss.SSSZ |
The guidelines to define the format are:
| Letter | Meaning |
|---|---|
| M | Month |
| d | Day |
| y | Year |
| h | Hour (0-12) |
| H | Hour (0-23) |
| m | Minute |
| s | Second |
| S | Milli Second |
| a | AM/PM |
| Z | Timezone |