如何在vb.net中合并字符串日期和时间并转换为军事格式的日期和时间？

I have a table with varchar data type and it stores:

stored in a
varchar field ---> date = 05/29/2013
varchar field ---> time = 7:00 PM

How do i merge this two in one and use the military time format just like:

will be stored in a datetime field  --> 05/29/2013 19:00

Will it be the easiest way to compute for time difference in PHP and MySQL? Any suggestion is very much appreciated. Thank you very much.

You can use the strtotime method to convert a string representation of a date/time into a timestamp which can then be used to format it any way you like with the date function

$dateString = '05/29/2013 7:00 PM';

echo date('m/d/Y H:i', strtotime($dateString));