[thelist] SQL Server/ASP and military time

[Max Wyss]

FWIW, in timetables, 24:00 is used for arrivals, and 0:00 is used for
departures.

In a similar way, one could establish a protocol to use 24:00 only
for _ending_ times, and in all other cases 0:00.

Max Wyss.

__________________________


>As every day both starts and ends with midnight, the two notations 00:00
>and 24:00 are available to distinguish the two midnights that can be
>associated with one date. This means that the following two notations refer
>to exactly the same point in time:
>1995-02-04 24:00 = 1995-02-05 00:00
>In case an unambiguous representation of time is required, 00:00 is usually
>the preferred notation for midnight and not 24:00. Digital clocks display
>00:00 and not 24:00.