代码如下:select EXTRACT(year FROM to_date(sysdate,'yyyy-mm-dd')) - EXTRACT(year FROM to_date('2008-04-30','yyyy-mm-dd')) as years
from T1;在PL/SQL中运行后,报错提示“literal does not match format string”,怎么回事?
from T1;在PL/SQL中运行后,报错提示“literal does not match format string”,怎么回事?
TO_NUMBER(TO_CHAR(SYSDATE,'YYY
------------------------------
31
from dual
from T1;