[thelist] SQL Server/ASP and military time

[Mike King]

ISO8601states:

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

So if you want to use 24:00 in your pages you'll have to check and alter
it, in and out of your SQL.

Cheers
mk

At 09:09 19/06/2002 -0400, Feingold Josh S wrote:
>--
>[ Picked text/plain from multipart/alternative ]
>I noticed that when ASP returns 12 midnight in military time via the
>formatdatetime() function it is returned as 00:00 and not 24:00 like the
>traditional military time.  Additionally, when I try to enter 24:00 into SQL
>Server it gives the error:
>
>"The conversion of a char data type to a datetime data type resulted in an
>out-of-range datetime value."
>
>Does anyone have any ideas how I can easily use normal military time?