Solved

does time(7) need to be in military time

Posted on 2014-04-29
7
297 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now