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

From: Jomarlen <jomarlen_at_aol.com>
Date: 1998/04/29
Message-ID: <1998042916160300.MAA16795_at_ladder01.news.aol.com>#1/1

>I hava a problem in validating date fields in PL/SQL.<BR>
>Basically I have 2 fields startdate and Enddate both<BR>
>are Varchar2(20)in the form which will be enterd by the users.<BR>
>Start date ----------(mm/dd/yyyy)<BR>
>end date ------------(mm/dd/yyyy)<BR>
>Because of company policy, I can use Java to validate<BR>
> at the client end. Now how do I verify enterd dates are valid.<BR>
>Is there built in date function to validate this?<BR>
>Like we have in ISS(Microsoft) Isdate().<BR>
><BR>
>I have an other problem<BR>
>Is there any fuction in Pl/Sql to validate enterd<BR>
>field is numeric.? Because I have amount field is varchar2(10).<BR>

Check out the Oracle Utilities page on my web site http://members.aol.com/jomarlen

You'll find what you are looking for there.

Regards
John

---

John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103

FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com

e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/

The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.

---

John

---

John C. Lennon
Utility Partners Inc.
Las Vegas

Web Site: http://members.aol.com/jomarlen/

The views expressed in this message
are those of the author and not
necessarily those of U.P.
and/or its employees. Received on Wed Apr 29 1998 - 00:00:00 CEST