This topic is locked

format Oracle time to asp

3/2/2010 5:53:50 AM
ASPRunnerPro General questions
B
boomer3828 author

Hello,
I have a field in my oracle database called LO_ACT_END_TIME

Within asp it gives me a value of for example 100812.

This is a correct time but I need it to display it within asprunner as 10:08:12
Next problem is that I sometimes need a leeding zero.

For example 93947 needs to be displayed as 09:39:47
I think that within the visual editor - properties I need to put in a formula (custom).
Is there someone who has a clue?
Thanks in advance