- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
function try_to_date(p_value in varchar2)
return date
is
l_date date;
l_fmt sys.odcivarchar2list := sys.odcivarchar2list('DD.MM.YYYY', 'YYYY/MM/DD', 'YYYY.MM.DD', 'dd.mm.yyyy', 'yyyy/mm/dd', 'yyyy.mm.dd');
begin
for i in 1..l_fmt.count loop
begin
l_date := to_date(p_value, l_fmt(i));
return l_date;
exception
when OTHERS then null;
end;
end loop;
return null;
end;