Oracle CAST Function Tips - Oracle Consulting, Oracle Support and Oracle Training by BC Or

Here are examples of using the CAST function: convert string to date select cast ('1997-10-22' as date) from dual; convert ROWID to char select * from t1 where cast (rowid as char(5)) = '01234'; convert string to timestamp select cast('22-oct-1997' as tim

www.dba-oracle.com