Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help needed. How to validate date in PL/SQL(Oracle Web Server)
On Tue, 28 Apr 1998 20:58:36 -0400, "Divakar" <kimmane_at_email.msn.com>
wrote:
>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.
>
>
Use owa_util.todate(p_datearray),
Received on Wed Apr 29 1998 - 01:37:36 CDT