Subtract Time

[sors]

SELECT A.USER_NAME,
      B.RESPONSIBILITY_NAME, C.USER_FORM_NAME USER_FORM_NAME2,  
      TO_CHAR(K.START_TIME, 'DD-MON-RR HH24:MI') START_TIME2, 
      TO_CHAR(K.END_TIME, 'DD-MON-RR HH24:MI') END_TIME2
FROM FND_LOGINS U, FND_LOGIN_RESPONSIBILITIES R,FND_USER A,
    FND_RESPONSIBILITY_VL B, FND_FORM_VL C, FND_LOGIN_RESP_FORMS K
WHERE (U.USER_ID = A.USER_ID) 
AND (R.RESPONSIBILITY_ID = B.RESPONSIBILITY_ID)
AND (U.LOGIN_ID = R.LOGIN_ID) AND (R.RESP_APPL_ID = B.APPLICATION_ID)
AND (R.LOGIN_ID = K.LOGIN_ID) AND (R.LOGIN_RESP_ID = K.LOGIN_RESP_ID) 

AND (K.FORM_APPL_ID = C.APPLICATION_ID) AND (K.FORM_ID = C.FORM_ID)
and to_date,(K.START_TIME,'hh24:mi') >to_date('18:00','hh24:mi')

ممكن اعرف ايه الغلط

[abdou1984]

يوجد Comma او فاصله فى السطر الاخير بعد To_Date
اعتقد انها سبب الخطأ .

[sors]

انا عايز عرف ازاى اقدر اطرح وقتين من بعض ياجماعة ضرورى جدا

[Ahmad.Hasan]

السلام عليكم
استخدم هذه:

Select Trunc ((To_Date (:Outtime, 'Hh24:Mi') - To_Date (:Intime, 'Hh24:Mi')) * 24) Hours,
(((To_Date (:Outtime, 'Hh24:Mi') - To_Date (:Intime, 'Hh24:Mi')) * 24)
- Trunc ((To_Date (:Outtime, 'Hh24:Mi') - To_Date (:Intime, 'Hh24:Mi')) * 24)) * 60 Minutes
From Dual

بالتوفيق.