A function that converts a text field to a date?

Question

Oracle

Please help me write a function in PL/SQL.
There is a BIRTHDAY field, it is text. It is necessary to carry out a check and bring to a general view, if possible.
Required format: DD.MM.YYYY

BIRTHDAY
-------------
1997-04-14
00.00.00
30.11.1961
1988-10-30T00:00:00:000
20.11.1982
1986-06-05

Answer 1

For each type of string, you need to set your own format in TO_DATE .
Found an implementation example: convert a string to a date .