Re: 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.
-----