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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Analytical Functions Question

Re: Analytical Functions Question

From: Dr Drudge <drdrudge_at_hotmail.com>
Date: 6 Feb 2004 11:37:12 -0800
Message-ID: <748419a0.0402061137.63f5c071@posting.google.com>


ak_tiredofspam_at_yahoo.com (AK) wrote in message news:<46e627da.0402050649.5a9ecaaf_at_posting.google.com>...
> Privet Yuri,
>
> I'd create a permanent calendar table, containing a row for each minute, like this:
> NUM TIME_FROM TIME_TO
> 1 02/04/2003 00:00:00 02/04/2003 00:00:01
> 2 02/04/2003 00:00:01 02/04/2003 00:00:02
> ...
> 60 02/04/2003 00:00:59 02/04/2003 00:01:00
>
> and so on
>
> That done, it would be easy to write the query you are asking about
>
> here are DB2 links, the syntax seems to be the same:
> http://www-106.ibm.com/developerworks/db2/library/techarticle/lyle/0110lyle.html
> http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0401kuznetsov/

Utter drivel...
That is just about the worst advice I have ever seen posted- even I can see that. Received on Fri Feb 06 2004 - 13:37:12 CST

Original text of this message

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