APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use the Extract Function

ProhanMay 9 2008 — edited May 10 2008

I must find a way to return from the sysdate:
The year.
The year after the current year.
E.g., if my date is 09-MAY-2008, I must return
2008
2009

I am told there is a way to do this with the Extract function, but don't know how. Can somebody show me please?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2008

Added on May 9 2008

#apex-discussions

8 comments

819 views