Re: Quantity of time from difference of two Datetime values?

2011-10-01 Thread Jan Steinman
Thanks, Hank! I figured it was something like that, but couldn't see any clear documentation on the Oracle reference page on date/time functions. On Sep 30, 2011, at 8:22 PM, Hank wrote: > n Fri, Sep 30, 2011 at 11:08 PM, Jan Steinman wrote: >> Okay, I've reviewed the online man page for date

Re: Quantity of time from difference of two Datetime values?

2011-10-01 Thread Hal�sz S�ndor
2011/09/30 20:08 -0700, Jan Steinman Okay, I've reviewed the online man page for date and time functions, and I've played with several likely candidates, and I am still having trouble subtracting two arbitrary Datetimes to get something that is useful. A simple subtraction yields the l

Re: Quantity of time from difference of two Datetime values?

2011-09-30 Thread Hank
n Fri, Sep 30, 2011 at 11:08 PM, Jan Steinman wrote: > Okay, I've reviewed the online man page for date and time functions, and I've > played with several likely candidates, and I am still having trouble > subtracting two arbitrary Datetimes to get something that is useful. A simple > subtracti

Quantity of time from difference of two Datetime values?

2011-09-30 Thread Jan Steinman
Okay, I've reviewed the online man page for date and time functions, and I've played with several likely candidates, and I am still having trouble subtracting two arbitrary Datetimes to get something that is useful. A simple subtraction yields the least useful thing possible: a modulo-100 differ