Hi,
you can use the TO_DATE function and capture the error that you get when
the date is incorrect (it's ORA-01839, by the way).
Hth,
Pavel
staylor_at_petrolsoft.com wrote in article
<6radch$uep$1_at_nnrp1.dejanews.com>...
> Hi there,
>
> I'm kinda a lazy bum, so I'm hoping there's an easy way to do this:
I'm
> creating a Web Application with OWAS 3.0 and I used the built-in function
> "OWA_UTIL.CHOOSE_DATE" which creates a drop-down list for the user to
select
> a date. It then puts this in a variable. What I'm wondering is this: Is
> there some kind of built-in function in OWAS or in Oracle that allows you
to
> check if the input is a valid date? i.e., if the user enters February
30,
> I'll know that it's incorrect. I know it probably wouldn't be too hard to
> write the function, but it would save me time if there's already a
built-in
> one.
>
> Thanks,
>
> Scott Taylor
> Petrolsoft Corporation
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Tue Aug 18 1998 - 09:28:45 CDT
