Re: 00:00:00 or 24:00:00

[Joep Beckeringh <joep@xxxxxxxxxxxxxxxxxxx>]

Hallo Peter,

See <http://en.wikipedia.org/wiki/ISO_8601>.

Joep Beckeringh


Peter.Colpaert@xxxxxxxxx schreef:
> 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.
> -----