<div>
if your app is international or maybe you use different delimiters for time, you can use &quot;short time&quot; as the 2nd argument in the format command. THis takes the international settings as defined in control panel.<br />

</div>


if your app is international or maybe you use different delimiters for time, you can use "short time" as the 2nd argument in the format command. THis takes the international settings as defined in control panel.


<div>
try this<br />
Format(&quot;10/04/2009 2:50:00 PM&quot;, &quot;dd/MM/yyyy hh:mm:ss&quot;) <br />
it will convert it to <br />
--------------------------<wbr />-<br />
10/04/2009 14:50:00<br />
--------------------------<wbr />-<br />

</div>


try this
Format("10/04/2009 2:50:00 PM", "dd/MM/yyyy hh:mm:ss")
it will convert it to
---------------------------
10/04/2009 14:50:00
---------------------------


<div>
<div class="content wysiwyg-content">
Hi Experts ,<br />
<br />
I have a database field with the time in the following format<br />
<br />
10/04/2009 2:50:00 PM<br />
<br />
I need to convert that to 14:50:00<br />
<br />
Could someone please show me how to <br />
<br />
Thanks
</div>
</div>


Hi Experts ,

I have a database field with the time in the following format

10/04/2009 2:50:00 PM

I need to convert that to 14:50:00

Could someone please show me how to 

Thanks

How to convert MS Access time format to 24 hour format

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.