About
Pricing
Community
Teams
Start Free Trial
Log in
Charles Baldo
asked on
12/21/2012
SQL Server 2005 Military Time
Can anyone tell me how to do military time in sql server 2005 all columns are date time
Microsoft SQL Server 2005
4
1
Last Comment
Charles Baldo
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Kyle Abrahams
12/21/2012
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
tim_cs
12/21/2012
Try convert.
http://msdn.microsoft.com/en-us/library/ms187928.aspx
CONVERT(varchar(12), DateField, 114)
Steve Wales
12/21/2012
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.
Charles Baldo
12/21/2012
ASKER
Thanks
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
CONVERT(varchar(12), DateField, 114)