How can I convert/change a value like 4:00 PM into "16:00:00.0" and 4:00 AM into "4:00:00.0" using vbscript/classic ASP. Note that it is going into a sql server db varchar field.
I could do it character-by-character but just wondering if there is a formatting tool available.
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>