wickedneat — 2011-12-28T14:59:42-05:00 — #1
I have a table as follows:
Columns = id, date
Id - Date
1 - 12-09-2011
2 - 12-28-2011
I need to do a select statement that will pull the amount of days between the two rows.
system — 2011-12-28T15:32:18-05:00 — #2
lots of ideas here
r937 — 2011-12-28T19:21:06-05:00 — #3
do you mean those two rows specifically? the rows with id=1 and id=2?
the actual date calculation is trivial
matching up the two rows you want is going to be a wee bit trickier