SQL & PL/SQL

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!

subtract dates and get a number!

604514Mar 6 2008 — edited Mar 6 2008

How can I subtract dates and get the difference in years in a number?

For example, 2012-02-19 - 2007-02-19, I would like that to be 5.

I have looked for converting date to integer or something but cannot find it.

Any other solution?

Best regards
Harald

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2008

Added on Mar 6 2008

9 comments

1,152 views