Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> PL/SQL Removing weekends

PL/SQL Removing weekends

From: <helen267_at_my-deja.com>
Date: Wed, 11 Oct 2000 01:18:48 GMT
Message-ID: <8s0f5k$5s8$1@nnrp1.deja.com>

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. Received on Tue Oct 10 2000 - 20:18:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US