Re: How to calculate time using SQL

From: Viktor <stant_98_at_yahoo.com>
Date: Mon, 01 Apr 2002 08:28:23 -0800
Message-ID: <F001.00437E30.20020401082823@fatcity.com>

Try this:

select to_date('10:20:32','hh:mi:ss') -
to_date('10:25:29', 'hh:mi:ss')
from dual
/

Viktor

• "Nguyen, David M" <david.m.nguyen_at_xo.com> wrote:
  > Is it possible to calculate seconds using SQL?
  >
  > For example, I'd like to subtract these two time
  > to get difference in
  > seconds:
  >
  > 10:20:32 - 10:25:29
  >
  > Thanks,
  > David
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Nguyen, David M
  > INET: david.m.nguyen_at_xo.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: stant_98_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Apr 01 2002 - 10:28:23 CST