I need to displays the previous ye

[vani65]

I need to displays the previous year in character format.
SELECT
TO_CHAR(TO_NUMBER(SYSDATE,'yyyy')-1),'YYYY')
FROM
dual
i'm trying to subtract 1 from a character string,I get an error msg stating
"FROM keyword not found where expected".

Please advice...thank you.

 

[SantaMufasa]

Vani,

You have two open parens and three close parens, which probably caused the "FROM" error. Here's what I get with a similar query:

select to_char(trunc(sysdate,'yyyy')-1,'yyyy') from dual;

TO_C
----
2002

1 row selected.

 

[vani65]

Ohhh thanks!

 

[Sudhi78]

SELECT TO_NUMBER(TO_CHAR(SYSDATE,'YYYY'),'9999')-1 FROM dual;

-Sudhí