| Neeraj |
Posted: Feb 12, 2008 02:04:38 AM |
Total Post: 258
Joined: Jan, 2007
|
hi,
is ther any bulit in function in sql by using i can get sum of time variables like :
18:50 + 22:50 =41:40
or i hav to make a function to calculate it ,if any one hav that function so plz send me.
thxs |
|
|
 Murtuja |
| Posted: Feb 12, 2008 03:40:55 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
You need to provide more information like
what is the datatype of variables?
where you want to store sum ?
variable's value coming from table ? if yes then datatype of that column.
|
|
|
|
|
| Neeraj |
| Posted: Feb 12, 2008 03:50:36 AM | |
|
Total Post: 258
Joined: Jan, 2007
|
this vales r comminf from database & type is nuber & wants to print on reports like :
empno time
123 14:30
123 11:50
sum 26:20
234 05:32
234 07:32
. .
. .
. .
sum ....
this kinda reprt i wanan make oracle reports on 10g
|
|
|
|
|
| newuser |
| Posted: Feb 22, 2008 02:27:13 AM | |
|
Total Post: 10
Joined: Feb, 2008
|
hi,
kindly refer this example
SELECT TO_NUMBER(TO_CHAR(SYSDATE,'HH24') + TO_CHAR(LOGIN_DT,'HH24'))
|| ':' || TO_NUMBER(TO_CHAR(SYSDATE,'MI') + TO_CHAR(LOGIN_DT,'MI'))
FROM EMP
Regards,
Nagaraj
|
|
|
|
|
| Neeraj |
| Posted: Feb 25, 2008 12:25:38 AM | |
|
Total Post: 258
Joined: Jan, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
