Re: Date arithmetic - performance dog?

[Hans Boldt <boldt@xxxxxxxxxx>]

Mlpolutta@xxxxxxx wrote:
> I wanted to see if you folks have found that ADDDUR and SUBDUR (etc.), and MOVEing to/from date fields are REALLY poor performers - it sure seems that way to me.  Is there a way to make such things perform well?

The performance of the date/time/timestamp operations is indeed a 
touch on the slow side. The reason is that each operation does a 
validity check on the values.

The only suggestion I have is that if you're converting from 
character or numeric to a D/T/Z value, don't check first using a 
TEST operation. Just convert directly using the appropriate built-in 
function (%DATE, %TIME, or %TIMESTAMP) wrapped in a MONITOR group. 
That will at least save one validity check.

For example:

MONITOR;
   DATE=%DATE(DSTR:*YMD);
ON-ERROR 112;
   DSPLY 'Egads! We have a bad date value!';
ENDMON;

Cheers! Hans