DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DATE DIFFERENCE

  1. 02-21-2002, 01:59 AM #1
    shailendra
    shailendra is offline Senior Member
    Join Date
    Sep 2000
    Posts
    305
    HI FRIENDS
    CAN ANYBODY WILL TELL ME HOW TO FIND DIFFERENCE BETWEEN TWO DATES IN NO OF HOURS?

    THIS IS URGENT

    THANKS IN ADVANCE
    Reply With Quote Reply With Quote
  2. 02-21-2002, 02:28 AM #2
    ales
    ales is offline Advisor
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    (Date1-Date2)*24
    Reply With Quote Reply With Quote
  3. 03-01-2002, 05:47 PM #3
    kris109's Avatar
    kris109
    kris109 is offline Professor Kris
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    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.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA
    Reply With Quote Reply With Quote
  4. 03-01-2002, 05:52 PM #4
    Shestakov
    Shestakov is offline Senior Advisor
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    http://www.dbasupport.com/forums/sho...threadid=21837
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width