Re: Analytical Functions Question

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