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

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

Bruce,

A friend of mine, Col. in the Army Reserve, once told me that the Army 
issues orders to reservists to report at "00:01" rather than "24:00" 
because, according to the reservists, that means they get paid for a day 
that just ended.  The military (U.S., anyway) never uses either 00:00 or 
24:00 for operational orders as it can lead to confusion and the last 
thing they need is confusion; things are tough enough.

	* Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
	615.995.7024
fax
	615.995.1201
email
	jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Bruce Vining wrote:
> If memory serves me right, the use of 24:00:00, to refer to the end of the day, is to accomodate previous (and long standing) standards used by the military.  As such ISO 8601 indicates:
>    
>   <quote>
>   day, calendar
>   time-interval starting at [0000] and ending at [2400] (which is equal to the beginning of the next calendar day);
>   typically a calendar day has a duration of 24 h
>   </quote>
>    
>   It is confusing to have two accepted ways to represent the same point in time and I do recall that this has always been a sore point with the chief database architect back in Rochester -- but a point that he (and us) have to live with...
>    
>   Bruce Vining
>   
> <snip>
> Larry Ducie <Larry_Ducie@xxxxxxxxxxx> wrote:
>   Hi Peter,
>
>
> 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?
>
>
> There are three different answers to this question:
> 1) Using standards agreed for formulating the appropriate representation of
> a designated time.
> In this case ISO 8601 is your guide and would suggest that they are the
> same. Both are correct.
> </snip>
>