convert string parameter value to time

How can we convert string parameter value to time format.

Find more posts tagged with

Comments

Can you provide a bit more information?
I have a string parameter which I convert within the open sql statement. Parameter promt : Enter Base Date e.g. yyyy-mm-dd
<pre class="_prettyXprint _lang-">
if(params["prefix"].value.toUpperCase().substring(params["prefix"].value.toUpperCase().indexOf("E") +1,params["prefix"].value.toUpperCase().search("E")) =="E") {
myWhere = " and (ca.enddate >= to_date('"+ params["baseDate"].value + "','mm-dd-yyyy') and SUBSTR (prl.gldebitacct, 1, 27) = ca.sub_glaccount) "
} else {
</pre>

Siva Rao

Hi williams, 
 
Thanks for your reply.
I have a parameter named as "starttime" and it's data type is string
I have to convert this string to time format

wwilliams

Well how is this string entered? what format is this string? 8:00:00 AM? 12 hour format or 24 hour format? 
hh:mm:ss or HH:mm:ss?

Siva Rao

in 12 hour format