12 hour format time in SQL datatype

• IT researcher

  SSCertifiable

  Points: 7602

  More actions

  November 3, 2014 at 11:53 pm

  #312230

  I can convert time datatype to 12 hour format using convert etc. But is there any option to save the time in 12 hour format in SQL tables using any settings or property or any other methods?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 4, 2014 at 2:11 am

  #1756471

  The time portion of a datetime can be saved in a column of datatype "time".

  The data is always saved in the internal representation, which is not 24 hours nor 12 hours: it is a time, nothing more.

  The human readable representation depends on how you format the data on the client application.

  See this article for more details:

  http://www.sqlservercentral.com/articles/T-SQL/88152/

  -- Gianluca Sartori