Best way to store time (hh:mm) in a database

by

You could store it as an integer of the number of minutes past midnight:

eg. 

0 = 00:00 
60 = 01:00
252 = 04:12

You would however need to write some code to reconstitute the time, but that shouldn’t be tricky.

More Related Contents:

  1. What columns generally make good indexes?
  2. Database design: Calculating the Account Balance
  3. Date range overlapping check constraint
  4. How to convert SQL Server’s timestamp column to datetime format
  5. How can I truncate a datetime in SQL Server?
  6. What is the significance of 1/1/1753 in SQL Server?
  7. How to create multiple one to one’s
  8. How to create materialized views in SQL Server?
  9. How Can I use “Date” Datatype in sql server?
  10. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  11. How to determine total number of open/active connections in ms sql server 2005
  12. Composite Primary key vs additional “ID” column?
  13. What’s the longest possible worldwide phone number I should consider in SQL varchar(length) for phone
  14. Handling date in SQL Server
  15. TSQL: Create a view that accesses multiple databases
  16. SQL Unique constraint across multiple tables
  17. How to create a yes/no boolean field in SQL server?
  18. SQL Server Group by Count of DateTime Per Hour?
  19. Executing set of SQL queries using batch file?
  20. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  21. How to store directory / hierarchy / tree structure in the database?
  22. SQL Server: convert ((int)year,(int)month,(int)day) to Datetime [duplicate]
  23. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  24. What are the advantages of VistaDB
  25. Generate table relationship diagram from existing schema (SQL Server) [closed]
  26. What are the limitations to SQL Server Compact? (Or – how does one choose a database to use on MS platforms?)
  27. How do you deal with blank spaces in column names in SQL Server?
  28. How does SQL Server decide format for implicit datetime conversion?
  29. Unique identifier (guid) as primary key in database design
  30. Single or multiple databases

Leave a Comment