Substracting two timestamp columns

ijunaid · #1 (**permalink**) 02-10-12, 12:30

Hi friends,

i have one serious issue that has to be sorted out soon,

I need to substarct two timestamp columns and need to get the result.
The requirement is just like substarct two timestamp columns.
Ex:
(1999-04-14 12:12:12) - (2009-02-15 12:12:12)

any help, advice from anyone will be appreciated

Warm Regards
junaid

anacedent · #2 (**permalink**) 02-10-12, 12:37

BTW - IMO what you posted were not TIMESTAMP, but DATE datatypes.

Code:

  1  select to_date('2009-02-15 12:12:12','YYYY-MM-DD HH24:MI:SS') -
  2	    TO_DATE('1999-04-14 12:12:12','YYYY-MM-DD HH24:MI:SS') INTERVAL
  3* FROM DUAL
SQL> /

  INTERVAL
----------
      3595

difference UNIT of Measure is DAYS

ijunaid · #3 (**permalink**) 02-24-12, 09:43

Ur Solution Helped me bro.!!
Thx a lot

Internet Services

Web Development

Digital Marketing

Consumer Tech