<div>
Thanks so much. &nbsp;I really appreciate the help. &nbsp;Both will work, but mwvisa1's solutions takes into account the am/pm factor. <br />
<br />
have a great day :-)
</div>


Thanks so much.  I really appreciate the help.  Both will work, but mwvisa1's solutions takes into account the am/pm factor.

have a great day :-)

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I'm using Scriptcase and in the onvalidate event, i want to format what the user entered as HH:MM (am/pm) to just bring in the military time, but i don't want it to show the colon, so if it is entered as 12:15 PM i would like it to convert to 1215 <br />
<br />
How can i do this?<br />
<br />
I have this <br />
{FormatTime}= Time_Format({ApptTime},hhi<wbr />i);<br />
<br />
Is this the correct way?<br />
Thanks :-)<br />
<br />
Laura
</div>
</div>


Hi Experts,

I'm using Scriptcase and in the onvalidate event, i want to format what the user entered as HH:MM (am/pm) to just bring in the military time, but i don't want it to show the colon, so if it is entered as 12:15 PM i would like it to convert to 1215 

How can i do this?

I have this 
{FormatTime}= Time_Format({ApptTime},hhii);

Is this the correct way?
Thanks :-)

Laura

convert 12 hr am/pm time to just hhmm in mysql

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.