<div>
Try convert. &nbsp;<a href="http://msdn.microsoft.com/en-us/library/ms187928.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms187928.aspx</a><br />
<br />
CONVERT(varchar(12), DateField, 114)
</div>


<div>
All the various date options for CONVERT for date are here:<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms187928.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms187928.aspx</a><br />
<br />
Take your pick for the one you need.
</div>


<div>
<div class="content wysiwyg-content">
Can anyone tell me how to do military time in sql server 2005 all columns are date time
</div>
</div>


Can anyone tell me how to do military time in sql server 2005 all columns are date time

SQL Server 2005 Military Time

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.