on 02-25-2009 2:47 AM
Hi Everyone,
If possible how would you given a numeric column in a database table that represents time in minutes:
-define an object in designer in the format hh:mm:ss while
-satisfying the condition permitting a sum aggregate on this object at a report level?
I can do a concatenation to get the format hh:mm:ss, however this is not of type time and can not be summed. Is there an alternative?
While this may not sound quite feasible as first glance, I do not want to be limited by my own preconceptions.
Thanks for any feedback.
Ken
Edited by: Banseka Kenneth on Mar 2, 2009 5:25 PM
Hi Ken,
If you wrap the db column in a sum statement then the data will aggregate first
TO_CHAR(SUM(In_Minutes)/60)||':'||TO_CHAR(MOD(SUM(In_Minutes),60))||':00'
That may do the job. It would only aggregate inthe query and not on the report though
Regards
Alan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.