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: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
Giving the table structures, sample input and expected output would be a good idea.
By
Vamsi
Previous Topic: Changing the schema within procedure
Next Topic: tuining sqlquery
Goto Forum:
  


Current Time: Sun Aug 20 18:16:02 CDT 2017

Total time taken to generate the page: 0.05013 seconds