HI FRIENDS
CAN ANYBODY WILL TELL ME HOW TO FIND DIFFERENCE BETWEEN TWO DATES IN NO OF HOURS?
THIS IS URGENT
THANKS IN ADVANCE
Printable View
HI FRIENDS
CAN ANYBODY WILL TELL ME HOW TO FIND DIFFERENCE BETWEEN TWO DATES IN NO OF HOURS?
THIS IS URGENT
THANKS IN ADVANCE
(Date1-Date2)*24
That plus the actual no of hours difference. You can use to_number(to_char(sysdate, 'HH24')) etc., to the find the difference in hours.