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!

How to find column data (values) format(s) from Oracle table

User_JL3CWFeb 3 2022

Hi,
I have a Oracle table with varchar column which is having datetime format data.
Few data is having the following format.
2021-11-17T11:42:34.000000
2/27/2019 11:30
09/20/2021 09:30:25
2021-09-24 09:30:14
There are 2.9 million rows. I would like to find how many different format(s) of column data is there ? Please let me know how to find this.
Thanks.

This post has been answered by Frank Kulash on Feb 4 2022

Jump to Answer

Added on Feb 3 2022

24 comments

1,924 views

1 mention