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!

i am getting a null on subtracting 2 dates...

user8731258Jul 28 2010 — edited Jul 29 2010

i am trying to subtract 2 dates
using the following query

select
TO_DATE( TO_CHAR(TRUNC(SYSDATE-1),'mm/dd/yyyy')||' 07:35:33 AM','MM/DD/YYYY HH:MI:SS AM')+10/1440
-
(TO_DATE( TO_CHAR(TRUNC(SYSDATE-1),'mm/dd/yyyy')||' 08:35:33 AM', 'MM/DD/YYYY HH:MI:SS AM')+10/1440)
from dual

but the result is null...
why????

i want to get the subtraction of the 2..how to get it??

This post has been answered by Tubby on Jul 28 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 26 2010

Added on Jul 28 2010

2 comments

1,157 views