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

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

瀏覽:670
日期:2024-05-18
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...看更多