没有isdate函数的,但可以自己写一个 create or replace function isDate(sdate in varchar2) return boolean is Result boolean; vdate DATE; begin SELECT to_date(sdate,'yyyy-mm-dd') INTO vdate FROM dual; Result := TRUE; return(Result); EXCEPTION WHEN OTHERS THEN Result := FALSE; return(Result); end isDate;
create or replace function isDate(sdate in varchar2)
return boolean is
Result boolean;
vdate DATE;
begin
SELECT to_date(sdate,'yyyy-mm-dd')
INTO vdate FROM dual;
Result := TRUE;
return(Result);
EXCEPTION
WHEN OTHERS THEN
Result := FALSE;
return(Result);
end isDate;