Post reply

days calculation problem in oracle

  • August 5, 2004 at 5:07 am

    #109023

    how do i calculate no. of days between 2 dates in oracle.

     

    select expiry_Dt-sysdate as noofdays from oracle ?? how exactly

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • August 5, 2004 at 8:01 am

    #517841

    a minus sign is correct. However you need to 'select sysdate from dual' to get back todays date.

    ------------------------------
    The Users are always right - when I'm not wrong!

  • August 5, 2004 at 10:30 pm

    #517940

    how exactly pls show it??

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • August 6, 2004 at 4:14 am

    #517980

    select (expiry_Dt)-(sysdate from dual) as noofdays

    ------------------------------
    The Users are always right - when I'm not wrong!

  • August 8, 2004 at 10:27 pm

    #518121

    it does'nt work have you checked that query ??

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • August 9, 2004 at 12:06 am

    #518127

    Try this

    select (Todate-FromDate) "NoOfdays" from dual.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply