get year now and 10 year before

Reply

•
•
Join Date: Jul 2006
Posts: 7
Reputation: am_dumb is an unknown quantity at this point 
Solved Threads: 0
am_dumb's Avatar
am_dumb am_dumb is offline Offline
Newbie Poster

get year now and 10 year before

 
0
  #1
Jan 16th, 2009
hy....
how to get year now and 10 year before with query
result is 2009,2008,2007,2006,......

thanx..
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2007
Posts: 2,134
Reputation: debasisdas will become famous soon enough debasisdas will become famous soon enough 
Solved Threads: 132
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Postaholic

Re: get year now and 10 year before

 
0
  #2
Jan 16th, 2009
you simply need to use TO_CHAR for the purpose and convert the sysdate to desired format.
Share your Knowledge.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the Oracle Forum
Thread Tools Search this Thread



Tag cloud for Oracle
2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy editor enterprise enterprise2.0 enterprisesoftware erp federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sql sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC