×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




Cool, 86400 rows per day and I sell disk. :-)
Now, anybody need ms?
- DrF

On 11/16/2021 1:30 PM, John Yeung wrote:
On Tue, Nov 16, 2021 at 12:19 PM Rob Berendt <rob@xxxxxxxxx> wrote:

It's still a technique being pushed today for use everywhere and not just Query/400.
https://db2ibmi.blogspot.com/2021/08/speed-dating-your-legacy-dates.html

Yeah. I pushed it on another thread just a few days ago.

However, OP is asking for times, not dates. You could still use the
same approach, creating a table with one row per second (given that
the field in question is 6 digits).

If this is an issue that comes up a lot, it still would be worth
considering. Doesn't introduce any new technology, and doesn't require
any learning if you've already done multifile queries before.

John Y.



This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.