RE: 00:00:00 or 24:00:00

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Hi Paul

We all know what assume does! See my previous post for an interesting 
result in SQL. That application does NOT think that 01 Jan 2000 24:00 
is really the same as 02 Jan 2000 00:00

Curiouser and curiouser!

Vern

At 07:23 AM 11/28/2007, you wrote:

> 24:00 implies duration, meaning midnight at the end of the day. 00:00
> implies no duration, meaning
> midnight at the beginning of the day.
>
> So your assumption that  01 Jan 2000 24:00 is really the same as 02 Jan 2000
> 00:00 is correct.
> And the standard says they are the same. :)  I don't believe that 01 Jan
> 2000 00:00 and 01 Jan 2000 24:00
> will compare to be equal,  though it would be cool if someone had time to
> test it.
>
> -Paul
>
>
>
> > -----Original Message-----
> > From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-
> > bounces@xxxxxxxxxxxx] On Behalf Of Peter.Colpaert@xxxxxxxxx
> > Sent: Wednesday, November 28, 2007 3:24 AM
> > To: rpg400-l@xxxxxxxxxxxx
> > Subject: 00:00:00 or 24:00:00
> >
> > Hi group,
> >
> > we're having a bit of a discussion here regarding time.
> >
> > One of our processes involves parsing a directory listing of a windows
> > shared drive, and there are 6 files which cause problems.
> >
> > These files have an entry in the listing as follows:
> >
> > 01/01/2000  12:00a             438,082 GN0229084.JPG
> >
> > The listing is parsed by two different programs (one made by me, the
> > other
> > made several years ago by another developer).
> >
> > His program (using pre-bif methods) returns the time as 00:00:00,
> > whereas
> > mine (using the %time built-in function) returns 24:00:00
> >
> > First of all, I'd like to know whether January 1, 2000 00:00:00 is the
> > same as January 1, 2000 24:00:00 (I would think that the latter
> > actually
> > means January 2).
> >
> > Second, which one is correct?
> >
> > Considering that the listing is using *USA time notation, I'm hoping
> > you
> > guys from across the pond can point me in the right direction.
> >
> > My suggestion to my project leader is to manually update the timestamp
> > to
> > 1 minute past midnight, and avoid the discussion altogether (what are
> > the
> > chances of new documents having a timestamp of midnight anyway)
> >
> > Thanks in advance,
> >
> > Peter Colpaert
> > Application Developer
> > PLI - IT - Kontich, Belgium
> > -----
> > Yoda of Borg are we.  Futile is resistance, assimilated will you be.
> > -----
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> > list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.