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: AK <ak_tiredofspam_at_yahoo.com>
Date: 5 Feb 2004 06:49:54 -0800
Message-ID: <46e627da.0402050649.5a9ecaaf@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/ Received on Thu Feb 05 2004 - 08:49:54 CST

Original text of this message

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