Link to home
Create AccountLog in
Avatar of Charles Baldo
Charles BaldoFlag for United States of America

asked on

SQL Server 2005 Military Time

Can anyone tell me how to do military time in sql server 2005 all columns are date time
ASKER CERTIFIED SOLUTION
Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Try convert.  http://msdn.microsoft.com/en-us/library/ms187928.aspx

CONVERT(varchar(12), DateField, 114)
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.
Avatar of Charles Baldo

ASKER

Thanks