nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

convert string parameter value to time

Siva Rao

How can we convert string parameter value to time format.

Find more posts tagged with

Comments

wwilliams

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