Re: Analytical Functions Question
Date: 6 Feb 2004 11:37:12 -0800
Message-ID: <748419a0.0402061137.63f5c071_at_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 - 20:37:12 CET