Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Verify date format

EricDBAEDQJun 2 2017 — edited Jun 5 2017

I have a date column that shows this format in the Results Browser when I select the Writer:

Oct 5, 2016 4:33:35 AM

but when I look at the report that is ran (an Excel file), the format of that same column is like this:

2016-10-05

Im trying to make sure all the columns with the date are consistent, but I don't know which one to go by. Also whenever I used the RegEx Check processor the columns with the data type as DATA, it shows as an Incompatible field.

Trying the Date Profiler with the same columns give the same results. Weird.

Any suggestions?
This post has been answered by Mike-Matthews-Oracle on Jun 5 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2017
Added on Jun 2 2017
#12c, #data-quality, #master-data-management-mdm
4 comments
763 views