Format Time display from query

[ken]

I am using the query bellow to display some fielsd on my page and am having
some problema displaying the data from calltime. I have the field setup in
access as short time but when it is displayed on the page it displays as
12:15 AM. How can I remove the AM/PM from the display?

Thanks
Ken
<%
notesSQL = "Select * From notes where callID =" &RSupdate("callID")
Set RScalls = dbConnection.Execute(notesSQL)
Do While Not RScalls.EOF
callscounter=callscounter+1
%>
<%=rscalls("notes")%> &nbsp;Added by: <%=rscalls("employee")%> on
<%=rscalls("notesdate")%> &nbsp;Time Spent: <%= rscalls("calltime") %><br>

[Tom Kaminski [MVP]]

"ken" <klsloan@ingr_Spam.com> wrote in message
news:eM**************@TK2MSFTNGP09.phx.gbl...

I am using the query bellow to display some fielsd on my page and am having some problema displaying the data from calltime. I have the field setup in
access as short time but when it is displayed on the page it displays as
12:15 AM. How can I remove the AM/PM from the display?

<%=rscalls("notesdate")%> &nbsp;Time Spent: <%= rscalls("calltime") %><br>

http://msdn.microsoft.com/library/en...atdatetime.asp

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

[Aaron Bertrand [MVP]]

So you don't care if it's 6:00 AM or 6:00 PM? Okay,

<%=split(rscalls("calltime"))(0)%>

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"ken" <klsloan@ingr_Spam.com> wrote in message
news:eM**************@TK2MSFTNGP09.phx.gbl...

I am using the query bellow to display some fielsd on my page and am having
some problema displaying the data from calltime. I have the field setup in
access as short time but when it is displayed on the page it displays as
12:15 AM. How can I remove the AM/PM from the display?

Thanks
Ken
<%
notesSQL = "Select * From notes where callID =" &RSupdate("callID")
Set RScalls = dbConnection.Execute(notesSQL)
Do While Not RScalls.EOF
callscounter=callscounter+1
%>
<%=rscalls("notes")%> &nbsp;Added by: <%=rscalls("employee")%> on
<%=rscalls("notesdate")%> &nbsp;Time Spent: <%= rscalls("calltime") %><br>