Home » SQL & PL/SQL » SQL & PL/SQL » Dates between
icon5.gif  Dates between [message #219414] Wed, 14 February 2007 05:22 Go to next message
Messages: 31
Registered: February 2007
Not sure if this is the wrong area to post this, if this isn't the right place, I'm sorry.

Basically, I want to specify 2 dates in an SQL Statement and check whether the 2 dates are a specific amount of time apart.

Ideally I would like to be able to calculate the percentage of records that are 1, 3 and 5 days apart as well as over 5 days, but if that sounds too difficult then just finding out how many fit into each category (which I would then convert into a percentage in ASP) would be great.

Thanks people.
Re: Dates between [message #219426 is a reply to message #219414] Wed, 14 February 2007 06:04 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Giving the table structures, sample input and expected output would be a good idea.
Previous Topic: Update statement
Next Topic: duplicate records
Goto Forum:

Current Time: Fri Apr 28 09:24:46 CDT 2017

Total time taken to generate the page: 0.08238 seconds