Database Administration (MOSC)

MOSC Banner

i want to get sum of time as hh:mi:ss

edited May 3, 2011 1:54AM in Database Administration (MOSC) 4 commentsAnswered
Hi,

My client is  working on time & attendance software and it required me to get the sum of overtimes,late coming and early going.actually i have the 3 character fields for overtime, late, early and at the end of the month i want to get the summary of  these fields in format of hh:mi:ss.For ex.  in overtime i may have different values for different days in format of hh:mi:ss and i want to calculate the summary of overtime for complete month.  and i am using sum function but its giving me the error as invalid number.so please if could you please resolve

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center