try converting it to a date.

begin
date_var:=to_date(string_var,'yyyyymmdd');
exception when value_error then ...
end;

-----Original Message-----
From: Claudio Bardelli
[mailto:oracledba-ezmlmshield-x97978131.[Email address protected]
Sent: Thursday, March 31, 2005 10:43 AM
To: LazyDBA Discussion
Subject: date validation.


Hello!

Anybody know about date validation, i,ve a variable of data type
varchar2 (8), (whit format "yyyymmdd"). I need to know if it variable is
a data type date valid.


Thanks!!!!


_________________________________________
Claudio, Bardelli
IT-Development
Deutsche Bank S.A. - Buenos Aires/Argentina
Tel: +54(11)-4590-2922 - DB Network: 88-590-2922
Fax: +54(11)-4590-2999 - DB Network: 88-590-2999


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page