Re: Help needed. How to validate date in PL/SQL(Oracle Web Server)

From: Young-chul,Jun <ycjun_at_hotmail.com>
Date: Wed, 29 Apr 1998 15:54:21 +0900
Message-ID: <6i6hoh$rmn$1@news.kren.nm.kr>

Try To_date function

in pl/sql use like this:

begin
temp_date := to_date(start_date,'mm/dd/yyyy'); exception when others
then htp.p('Wrong Date format!!');
end;

Young-chul,Jun         ycjun_at_hotmail.com
                                ycjun_at_samsung.co.kr

Samsung SDS, Korea

Divakar ÀÌ(°¡) ¸Þ½ÃÁö¿¡¼­ ÀÛ¼ºÇÏ¿´½À´Ï´Ù...
>Hi,
>I am working on Oracle web server3.0.
>I hava a problem in validating date fields in PL/SQL.
>Basically I have 2 fields startdate and Enddate both
>are Varchar2(20)in the form which will be enterd by the users.
>Start date ----------(mm/dd/yyyy)
>end date ------------(mm/dd/yyyy)
>Because of company policy, I can use Java to validate
> at the client end. Now how do I verify enterd dates are valid.
>Is there built in date function to validate this?
>Like we have in ISS(Microsoft) Isdate().
>
>I have an other problem
>Is there any fuction in Pl/Sql to validate enterd
>field is numeric.? Because I have amount field is varchar2(10).
>
>Please advice me.(This is bit urgent)
>Thanks,in advance.
>
>
Received on Wed Apr 29 1998 - 01:54:21 CDT