SQL & PL/SQL

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!

Checking Date Format of a date column value for a table

LazarJan 2 2018 — edited Feb 3 2018

Hi All,

Is there any possibility for a DATE column to hold a value 02-01-18 with the date format DD-MM-RR , where its actual format is 'DD-MM-RR'(02-JAN-18) as per the NLS_DATE_FORMAT .

Table : test1

Customer_DOB

22-JAN-87

11-Nov-81

15-06-75

22-JUN-56

Is these case can happen through any DML or any data upload through external tools?????

Since im doing some data cleansing and analysis on a particular table. I would like to understand possibility on these sort of cases.

If possible, please let me know the query to extract the wrong formatted one...

DB version - Oracle 12C

This post has been answered by cormaco on Jan 2 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 30 2018

Added on Jan 2 2018

6 comments

9,139 views