Member Avatar for am_dumb

hy....
how to get year now and 10 year before with query
result is 2009,2008,2007,2006,......

thanx..

  • 4 Contributors
  • 3 Replies
  • 125 Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by baki100
Member Avatar for debasisdas

you simply need to use TO_CHAR for the purpose and convert the sysdate to desired format.

Member Avatar for violette

is there any other option to get the solution?

Member Avatar for baki100 
select to_char( add_months(sysdate, (-12*level)) , 'yyyy') years 
from dual
connect by level <= 10
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.