Re: Timestamp edit code problem with midnight as 00:00:00 but I want 24:00:00

Also be careful with 24:00:00 instead of 00:00:00. We had a Visual Basic
program getting data from our files for a web screen. The program couldn't
handle the 24:00:00 time. If I need to use *hival on a time, I now
subtract 1 min to make it 23:59 to prevent web problems.




Keith Carpenter <carpcon@xxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
05/16/2007 03:28 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: Timestamp edit code problem with midnight as 00:00:00 but I want
24:00:00






Booth Martin wrote:

I am having a timestamp edit code problem with midnight as 00:00:00 but
I want 24:00:00

I can not figure out how to have a timestamp be, for example,
2007-05-15-23:00:00 + %hours(1) = 2007-05-15-24:00:00
instead of
2007-05-15-23:00:00 + %hours(1) = 2007-05-16-00:00:00

24.00.00 is a valid time for timestamp, but I don't see a format for it.
If you must, you could make a procedure to test for 00.00.00 and then
change to 24.00.00 Just set the date back a day by subtracting 1
second. Then set the micro seconds to zero and the time to 24.00.00


Keith