on 10-20-2008 9:42 PM
Hi
How can i add minutes to a date time stamp objects in desktop intelligence report.Have a solution in universe level
Select sysdate, sysdate + interval '5' minute from dual;
but is this possible in report level.
adds minutes for ex when the number of minutes exceeds 59 it adds 1 hour if the number of hours exceeds 23 it should add a day if the number of days exceeds to 30 or 31 it should add a month .
I have tried the same using the Substr() function which adds the minutes but when the number of minutes exceeds 59 it adds an hour if the number of hours exceed 23 from there the formula fails.
Thanks in Advance
Rohit
Hi Rohit,
When working with the hour, minutes, seconds date parts, then I would suggest you try to do this at universe level making use of database functions.
If you want to handle this at report level, then you need to roll up the time from minutes, hours, days, months, years and this gets quite messy.
As mentioned, at universe level the soltion is a lot cleaner and re-usable.
Hope this helps
Jacques
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.