[thelist] SQL Server/ASP and military time

[Feingold Josh S]

--
[ 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?

Thanks,
Josh