current year sql oracle

Solutions on MaxInterview for current year sql oracle by the best coders in the world

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
showing results for - "current year sql oracle"
Antonella
11 Apr 2017
1SELECT extract(YEAR FROM sysdate) FROM dual;			// number
2SELECT to_char(sysdate, 'YYYY') FROM dual;				// varchar