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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to calculate interval as date

Igor S.Jan 18 2013 — edited Jan 21 2013

Hi Experts,

I am looking for a way to calculate interval between two dates. And get the result in 'dd.mm.yyyy hh24:mi:ss' format.

select  sysdate - to_date('1.1.2000 12:00:00','dd.mm.yyyy hh24:mi:ss') from dual

Any best practices for a problem like this?

Best regards,
Igor

This post has been answered by Anton Scheffer on Jan 21 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 18 2013

Added on Jan 18 2013

7 comments

1,056 views