SQL Server 2005 Military Time

Can anyone tell me how to do military time in sql server 2005 all columns are date time
Charles BaldoSoftware DeveloperAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Kyle AbrahamsConnect With a Mentor Senior .Net DeveloperCommented:
SELECT CONVERT(CHAR(8),GETDATE(),14) -- hh:mm:ss

SELECT CONVERT(CHAR(30),GETDATE(),14) -- hh:mm:ss:miliseconds.
0
 
tim_csCommented:
Try convert.  http://msdn.microsoft.com/en-us/library/ms187928.aspx

CONVERT(varchar(12), DateField, 114)
0
 
Steve WalesSenior Database AdministratorCommented:
All the various date options for CONVERT for date are here:

http://msdn.microsoft.com/en-us/library/ms187928.aspx

Take your pick for the one you need.
0
 
Charles BaldoSoftware DeveloperAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.