Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The ISDATE program determines whether a text expression represents a valid date. ISDATE only tests a text expression to see if it can be converted to a DATE-only value; it does not actually make the conversion. You must use CONVERT to make the conversion.
BOOLEAN
YES
when the text expression represents a valid date; NO
when it does not.
ISDATE(test-date)
A single-line ID or TEXT expression to be examined to see if it represents a valid date, as defined by the DATE-only data type. For a description of the valid styles for entering dates, see "Date-only Input Values".
OLADM1722Example 7-132 Testing a Text Expression
In the following statement, the ISDATE program tests a literal text expression to see if it is a valid date, and the output is sent to the current outfile.
SHOW ISDATE('3 5 1995')
This statement produces the following output.
YES