Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get minutes????
First, subtract the two date fields and then convert it to time
"Time(log_end_date - log_start_date)". Second, you probably should put out
the difference in days AND time.
"William F. O'Neill" <wfoneill_at_mindspring.com> wrote in message
news:aer7mn$5sn$1_at_slb2.atl.mindspring.net...
> Am using Powerbuilder 8.0.2 with Oracle9i on WIN2K
> Am attempting to create a report, in which I must take the 'time' value of
> one field and substract it from the 'time' value of another field, and
have
> the result in minutes. I will of course use a 'computed field' to
> accomplish this, but nothing I've tried seems to work. Think the problem
> lies with how to do this with Oracle within PB. Time(log_end_date) -
> time(log_start_date) burps! Have a feeling I should use convert(), but
don't
> know the parameters... Any hints?
>
>
>
>
>
>
Received on Wed Jun 19 2002 - 19:59:22 CDT