Re: Timestamp edit code problemwithmidnight as00:00:00butIwant24:00:00

When talking with humans, I think everyone will agree that 2400 and 0000 both refer to midnight.

But as a programmer, if I ever need to know which is which, it's time to ask the computer. On my v5r2 machine:

d time1 s t d time2 s t d timestamp1 s z d timestamp2 s z /free time1 = %time('24.00.00'); time2 = %time('00.00.00'); dsply time1; dsply time2; if time1 = time2; dsply 'are equal'; else; dsply 'are NOT equal'; endif; timestamp1 = %timestamp('2007-05-01-24.00.00.000000');
timestamp2 = %timestamp('2007-05-02-00.00.00.000000');
dsply timestamp1;
dsply timestamp2;
if timestamp1 = timestamp2;
dsply 'are equal'; else; dsply 'are NOT equal';
endif; *inlr = *on; /end-free

the results are:

DSPLY 24.00.00 DSPLY 00.00.00 DSPLY are NOT equal

DSPLY 2007-05-01-24.00.00.000000
DSPLY 2007-05-02-00.00.00.000000
DSPLY are NOT equal
Actually, I was sort of expecting the timestamps to be equal...

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /

They are different, yet the same as they are two different ways of referring
to the same thing, i.e. midnight. It makes sense for computers to work on
the 00:00:00.000000 to 23:59:59.999999 range as there are fewer rollover
checks to make when incrementing the low-ordinal values.

Jonathan