Re: Difference between dates in seconds (9i)

From: Michael Gill <mydba_at_usa.com>
Date: 9 Nov 2003 17:43:02 -0800
Message-ID: <fb510dcd.0311091743.5fdbe18e@posting.google.com>

Oh, thanks so much, Jan. I've seen the extract function, but thought it was limited to dates. I can't wait to get back to work tomorrow and try it!

Gratefully,
Michael

jmourik_at_yahoo.com (Jan van Mourik) wrote in message news:<ffe966de.0311071418.44f8feba_at_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 Sun Nov 09 2003 - 19:43:02 CST