How to get 24 hours date format?

hi i want to get something like this

18.09.2008 18:30

instead of

18.09.2008 06:30 PM

 

any idea?

 
SqlConnection con = ConnectionManager.con();
string sql = "insert into tb_comments (commentfrom, commentto,commentdate,picture_id,comment_content) values(@UserFrom,@UserTo,@CommentDate,@ImageID,@CommentText)";
SqlCommand cmd = Go to the complete details ...