Time Format in ASP 1

[pupadu]

Hello everyone and anyone.

I know that there is a real simple solution to this beginner's problem but for the life of me, I can't find the solution for this.

I'm using ASP with an SQL database. I need to convert datetime data such as "17:00:00" into "5:00 PM". I've tried "vbshorttime" but I get "05:00:00 PM".

Any and all help is and will be greatly appreciated.

 

[steven290]

try

<%
timenow="17:00:00"
response.write formatdatetime(timenow,vbLongTime)
%>

 

[steven290]

if it still does has a 0 you can use this function

function fixtime(strtime)
strtemp=FormatDateTime(strtime, vbLongTime)
if left(strtemp,1)="0" then 
strtemp=mid(strtemp,2)
end if
fixtime=strtemp
end function

test it like this

timenow="17:00:00"
response.write fixtime(timenow)

 

[pupadu]

Thanks so much steven290 for responding. I do appreciate your help. However, this didn't work. It's displaying as "5:00:00 PM".

Any other ideas? I'm wide open to them, believe me.

 

[steven290]

oh didn't see that you wanted to remove the seconds, give me a few and i'll get back to you

 

[steven290]

try something like this, i didnt test it

function fixtime(strtime)
strtemp=FormatDateTime(strtime, vbLongTime)
if left(strtemp,1)="0" then
strtemp=mid(strtemp,2)
end if
arrtime=split(strtemp,":")
fixtime= arrtime(0)&":"&arrtime(1)&" "&right(arrtime(2),2)
end function

 

[pupadu]

Steven290, you are amazing! Thank you, thank you, thank you so much. I was thinking about splitting the time but I was way off by not thinking about the LEFT and MID functions. Again, thank you so much! I absolutely love this forum. I know it's corny but I just had to get that off my chest.

 

[steven290]

Glad it worked out for you.


please provide stars to those that helped you.

 

[pupadu]

Steven290, you just earned yourself a star from me.

 

[steven290]

cool thanks