• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

does time(7) need to be in military time

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
al4629740
Asked:
al4629740
  • 3
  • 3
1 Solution
 
duttcomCommented:
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
 
al4629740Author Commented:
So the answer is no.
0
 
duttcomCommented:
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
al4629740Author Commented:
It might be too complicated for me to do it.  I just need a datatype to show it.
0
 
duttcomCommented:
Try something like this in your select statement -

select CONVERT(varchar(15),YourTimeField,100) as YourTimeField
0
 
al4629740Author Commented:
Yes, thank you.  The main objective was to have it displayed inherently in the table.

Again.  Thanks
0
 
PortletPaulCommented:
>> "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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now