1

Topic: Oracle BI 11g, a field the period of dates

Good afternoon;
The table in which there is a field containing dates - dat is given.
In the designer of reports it is necessary to create a calculated field in which we will be calculated the period in minutes on this field.
I assume to calculate max and min dates in a dial-up and their difference to increase on 24*60 about one minutes (as becomes in oracle):
EVALUATE_AGGR (' (max (%1) - min (%1)) * 24 * 60 ', O.dat)
There is an error
State: HY000. The code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] There was a general error. [nQSError: 43113] from OBIS the message is returned. [nQSError: 43119] request failure: [nQSError: 46035] Type conversion of the data (DOUBLE PRECISION) with possible indefinite values (1), unicode (1), external char (0) to data type (TIMESTAMP) with possible indefinite values (1), unicode (0), external char (0). (HY000)

2

Re: Oracle BI 11g, a field the period of dates

vint44;
TIMESTAMPDIFF (SQL_TSI_MINUTE, min ("Day"), max ("Day"))
If at you date date, instead of datetime,
TIMESTAMPDIFF (SQL_TSI_DAY, min ("Day"), max ("Day")) *24*60

3

Re: Oracle BI 11g, a field the period of dates

Thanks!