Re: An easy (I think) SQL question

On 29-Jun-2016 08:52 -0500, Kevin Bucknum wrote:

An option that I haven't seen mentioned is a date conversion table.
A properly indexed conversion table can be very fast when compared
to doing conversion functions. I know IBM shipped one in their DB2
web query product, and I've seen a script to create one during a
seminar, but I can't find either of them searching ATM. Maybe someone
else on the list knows the routine to create it.

The topic has been covered fairly often, though indeed, often mention of the technique is often neglected each time a more recent topic about such conversions arises :-(

Here is such a script; well, one statement anyhow, that generates the required data [as a CTE derived table for a SELECT using a RCTE rather than as a permanent table], and merely for C={0,1} of CYYMMDD:
[http://archive.midrange.com/rpg400-l/201601/msg00009.html]