Torna al Thread

CREATE OR REPLACE FUNCTION WB_IS_DATE_MY ("P_VAR" IN VARCHAR2, "P_FORMAT" IN VARCHAR2) RETURN NUMBER IS p_date DATE; BEGIN if (p_format is null) then p_date := TO_DATE(p_var); else p_date := TO_DATE(p_var, p_format); end if; IF (p_date is null) then return 0; else return 1; end if; EXCEPTION WHEN OTHERS THEN RETURN 0; END; /
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5