From: helen267@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: PL/SQL Removing weekends
Date: Wed, 11 Oct 2000 01:18:48 GMT
Organization: Deja.com - Before you buy.
Lines: 17
Message-ID: <8s0f5k$5s8$1@nnrp1.deja.com>
NNTP-Posting-Host: 203.109.252.19
X-Article-Creation-Date: Wed Oct 11 01:18:48 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
X-Http-Proxy: 1.1 cache8.ihug.co.nz:3128 (Squid/2.4.DEVEL2), 1.0 x70.deja.com:80 (Squid/1.1.22) for client 203.173.218.46, 203.109.252.19
X-MyDeja-Info: XMYDJUIDhelen267


Hi there

I'm trying to write a simple PL/SQL script (for a stored procedure)
that will count the number of weekend days, i.e Saturday and Sunday,
that occur between two dates.  I thought I had it right, but I can't
for the life of me work out why it's not working!

Has anyone done anything similar and could help me out, either by
checking the script I have so far, or writing a quick solution?

Thanks in advance

Helen


Sent via Deja.com http://www.deja.com/
Before you buy.