SUBSTR(FIRST_NAME,2), --if you didnt specify the n value, then it will be to the end of string SUBSTR(FIRST_NAME,-3)--if m is negative , then the count start from the end SELECT TRIM (' ' FROM ' ...
select months_between(sysdate,to_date('25-sep-2006')) from dual; select months_between(sysdate,to_date('25-sep-2006'))/12 from dual; select to_char(to_Date('25-sep ...