Re: Is Date:
From: Yong Huang <yong321_at_yahoo.com>
Date: 5 Oct 2001 21:11:05 -0700
Message-ID: <b3cb12d6.0110052011.3a580425_at_posting.google.com>
Date: 5 Oct 2001 21:11:05 -0700
Message-ID: <b3cb12d6.0110052011.3a580425_at_posting.google.com>
Both Connor and Sybrand's answers are good. The problem is that the date format has to be specified. I imagine what you expected is not what their answer gives you. I.e., it may be better you simply check the string passed in against all strings you're willing to accept as a date string, in more formats than Oracle supplies. So it's not an Oracle question. Perl is the best language.
Yong Huang
yong321_at_yahoo.com
"Allan Martin" <allan.martin_at_saic.com> wrote in message news:<3bbd29aa_at_cpns1.saic.com>...
> Does anyone know of an IS_Date function or similar, where I could send it a
> string and if it was in a date format, it would return true or false if not?
>
> Allan
Received on Sat Oct 06 2001 - 06:11:05 CEST