Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Mumbai, India
    Posts
    3

    Arrow Unanswered: select number of days

    Hi,

    I want to select the number of days between 2 specific dates where the day between any of the 2 dates is NOT SATURDAY OR SUNDAY.
    eg.

    I want to select no. of days between 21/01/2002 and 10/01/2002,
    where any of the DAYS FALLING BETWEEN THE 2 DATES IS NOT A SATURDAY OR A SUNDAY.

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189
    Hello,

    I think the best way to do this is to write a PL/SQL function and use it
    in your Select statement.

    Greetings

    Manfred Peter
    (Alligator Company)
    http://www.alligatorsql.com

Posting Permissions

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