select number of days [Archive]

View Full Version : select number of days

maithilyerande

01-23-02, 04:47

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.

alligatorsql.com

01-23-02, 15:44

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