Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Difference between dates in seconds (9i)

Re: Difference between dates in seconds (9i)

From: Jan van Mourik <jmourik_at_yahoo.com>
Date: 7 Nov 2003 14:18:03 -0800
Message-ID: <ffe966de.0311071418.44f8feba@posting.google.com> 





> I don't want to display the value! I need to extract the hours,minutes

> and seconds to save the number of seconds.




Michael,  try the extract function:


http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/functions42a.htm#1017163



jan



om mani padme hum
Received on Fri Nov 07 2003 - 16:18:03 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US