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
abis123
Messages: 31
Registered: February 2007
Member
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.
By
Vamsi
Previous Topic: Update statement
Next Topic: duplicate records
Goto Forum:
  


Current Time: Thu Dec 08 16:30:00 CST 2016

Total time taken to generate the page: 0.09373 seconds