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,format in varchar2) ... SELECT to_date(sdate,format) INTO vdate FROM dual;
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,format in varchar2)
...
SELECT to_date(sdate,format)
INTO vdate FROM dual;