We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
2 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL Server 2005 Military Time
Posted on 2012-12-21
Can anyone tell me how to do military time in sql server 2005 all columns are date time
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4 Comments
Active today
SELECT CONVERT(CHAR(8),GETDATE(),
SELECT CONVERT(CHAR(30),GETDATE()
SELECT CONVERT(CHAR(30),GETDATE()
Try convert. http://msdn.microsoft.com/en-us/library/ms187928.aspx
CONVERT(varchar(12), DateField, 114)
CONVERT(varchar(12), DateField, 114)
Active 5 days ago
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.
http://msdn.microsoft.com/en-us/library/ms187928.aspx
Take your pick for the one you need.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):
. Check for publisher's certificate revocation
. Check for server ce…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Suggested Courses
Course of the Month2 days, 11 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
695 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.