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
Solved

does time(7) need to be in military time

Posted on 2014-04-29
7
308 Views
Last Modified: 2014-04-30
In the database, I have a column set to time(7)

Do time values always have to be in military time.  Can't they be in the normal time?
0
Comment
Question by:al4629740
  • 3
  • 3
7 Comments
 
LVL 12

Accepted Solution

by:
duttcom earned 500 total points
ID: 40030942
The time format is HH:MM:SS and as such there is no value for a.m. or p.m. that would allow you to use 12 hour time instead of 24 hour time.
0
 

Author Closing Comment

by:al4629740
ID: 40030951
So the answer is no.
0
 
LVL 12

Expert Comment

by:duttcom
ID: 40030954
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:al4629740
ID: 40030960
It might be too complicated for me to do it.  I just need a datatype to show it.
0
 
LVL 12

Expert Comment

by:duttcom
ID: 40030972
Try something like this in your select statement -

select CONVERT(varchar(15),YourTimeField,100) as YourTimeField
0
 

Author Comment

by:al4629740
ID: 40031016
Yes, thank you.  The main objective was to have it displayed inherently in the table.

Again.  Thanks
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 40031419
>> "The main objective was to have it displayed inherently in the table."

not sure what "displayed inherently" means, but a Time(7) field is NOT stored "in a format" at all. Date/Time information is actually stored as integers, but presented to us mere humans in a fashion that we comprehend as dates and/or times. e.g.

select YourTime7_field from yourtable;

will display a "default" time format, probably HH:MM;SS +0000000 and I don't think that default can be altered. You can however specify the format you want to see using convert e.g.
    CREATE TABLE Table1
    	([MyTime7] time(7))
    ;
    	
    INSERT INTO Table1
    	([MyTime7])
    VALUES
    	('23:35:45')
    ;

**Query 1**:

    select
      MyTime7
    , convert(varchar, MyTime7 ,9) am_pm_full_precision
    from table1
    

**[Results][2]**:
    
    |          MYTIME7 | AM_PM_FULL_PRECISION |
    |------------------|----------------------|
    | 23:35:45.0000000 |   11:35:45.0000000PM |



  [1]: http://sqlfiddle.com/#!6/2fd45/8

Open in new window

also see http://www.experts-exchange.com/Database/MS-SQL-Server/A_12315-SQL-Server-Date-Styles-formats-using-CONVERT.html
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question