We're using Oracle Designer to do our design.

We're doing a trigger that that will submit a
DBMS_JOBS for every 12 months.

When I code to_char(name,null,'DD-MON-YYYY:HH:MI:SS' I want to take the sysdate and add 12 (for 12 months). I get an error that's it's invalid type.

Can any one tell how to write a to_char date conversion with 12 months out ?

Thanks.

John DeUnger




Oracle LazyDBA home page