time help

[chrismartz]

How can I get rid of the 00 in 3:45:00 PM? I know there isnt a quick solution as I hear, but is there?!

[Juuitchan]

You don't seem very resourceful.

Look for the second colon, and erase it and the next two characters.

[Juuitchan]

You don't seem very resourceful.

Look for the second colon, and erase it and the next two characters.

[chrismartz]

Why did you have to post that twice? Also, how do I look for the second colon?

[Juuitchan]

Sorry. I was having browser problems.

I don't know what language you're using, but isn't there a "search" feature for strings? If not, why not write your own?

Or... if the language has built in date/time capabilities, write your own time-to-string function.

[chrismartz]

That is why I am posting in the ASP section of this forum, because I program in ASP.

[Danbabe]

Are you using ASP scripts? If so, I can help.

Dan

[chrismartz]

I figured out the coding and used:

<%
Dim DT,Length,TheTime,AMPM
DT = rs.fields("time_posted")
Length = LEN(DT)
TheTime = LEFT(DT, Length - 6)
AMPM = RIGHT(DT, 2)
DT = TheTime + " " + AMPM
Response.Write DT
%>