Skip to Main Content
Forums

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!

Need date difference in Minutes

user535789Oct 17 2007 — edited Oct 18 2007
Hi,
I want to get the difference of date in minute.
Please help me out.
format is mentioned below in the query

select (to_date('9/19/2007 8:02:33 PM', 'MM/DD/RRRR HH12:MI:SS AM')
- to_date('9/19/2007 7:02:02 PM', 'MM/DD/RRRR HH12:MI:SS AM'))
from dual


Regards
Amit
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2007
Added on Oct 17 2007
9 comments
660 views