What is wrong with the following:
select cast(sysdate as varchar2(20)) from dual;
Te error message i get is:
select cast(sysdate as varchar2(20)) from dual
*
ORA-00905: missing keyword
?? please help
(What i try to do is to cast several things (the above is just an example) but don't want to use the to_date, to_number etc. functions but the cast function)
select cast(sysdate as varchar2(20)) from dual;
Te error message i get is:
select cast(sysdate as varchar2(20)) from dual
*
ORA-00905: missing keyword
?? please help
(What i try to do is to cast several things (the above is just an example) but don't want to use the to_date, to_number etc. functions but the cast function)