Barbara Baker wrote:
SQL> SQL> selectIt looks like your statement is formatted incorrectly... Count the ('s and )'s
to_date(to_char(crdate,'ddmmyyyy')-1000),'MM/DD/YYYY')
2 from customer where cusno=798489;
select
to_date(to_char(crdate,'ddmmyyyy')-1000),'MM/DD/YYYY')
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
select to_date*(*to_char*(*crdate,'ddmmyyyy'*)*-1000*)*,'MM/DD/YYYY'*)* from customer where cusno=798489;
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------