oracle中判断是否为日期型:
create function is_date(p_date in varchar2)
return number
as
v_date date;
begin
v_date:=to_date(p_date,"yyyy-mm-dd");
return 1; --正确
exception
when others then
return 0;
end;
create function is_date(p_date in varchar2)
return number
as
v_date date;
begin
v_date:=to_date(p_date,"yyyy-mm-dd");
return 1; --正确
exception
when others then
return 0;
end;