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

Home -> Community -> Usenet -> c.d.o.misc -> Help? Select latest and earliest date from a row containing three dates.

Help? Select latest and earliest date from a row containing three dates.

From: Dan Gray <dan_at_dangray.org>
Date: 11 Jun 2003 11:53:25 -0700
Message-ID: <8c6ba53b.0306111053.6c1fbe28@posting.google.com> 





Hi,


 I'm stuck. Any one got any feedback on how to select from a database
containing...



pa1date    | pa2date    | pa3date


2003-03-03 | 2003-04-03 | 2003-05-03



 The lowest, middle and highest dates individually on request? It's a
stats program and while I've written a perl routine to pull all three
dates and them parse then into order it's not very elegant and there
must be a way to do it is SQL, I just can't find it!



   Regards


     Dan Gray
Received on Wed Jun 11 2003 - 13:53:25 CDT












Original text of this message













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