Why is SQL Server losing a millisecond?

by

SQL Server only stores time to approximately 1/300th of a second. These always fall on the 0, 3 and 7 milliseconds. E.g. counting up from 0 in the smallest increment:

00:00:00.000
00:00:00.003
00:00:00.007
00:00:00.010
00:00:00.013
…

If you need that millisecond accuracy, there’s no pleasant way around it. The best options I’ve seen are to store the value in custom number fields and rebuild it every time you fetch the value, or to store it as a string of a known format. You can then (optionally) store an ‘approximate’ date in the native date type for the sake of speed, but it introduces a conceptual complexity that often isn’t wanted.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Max sal to print base on manager_id
  3. Can I use CASE statement in a JOIN condition?
  4. sql server 2008 management studio not checking the syntax of my query
  5. Create a date from day month and year with T-SQL
  6. How to create a table from select query result in SQL Server 2008 [duplicate]
  7. Effect of NOLOCK hint in SELECT statements
  8. How to do a case sensitive search in WHERE clause (I’m using SQL Server)?
  9. SQL Server – stop or break execution of a SQL script
  10. What is the difference between using a cross join and putting a comma between the two tables?
  11. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  12. Pivot Table and Concatenate Columns
  13. Natural join in SQL Server
  14. Pivot using SQL Server 2000
  15. Transfer data from one database to another database
  16. Concat field value to string in SQL Server
  17. How to update and order by using ms sql
  18. Using Excel VBA to run SQL query
  19. How to store image in SQL Server database tables column [duplicate]
  20. SQL performance: WHERE vs WHERE(ROW_NUMBER)
  21. The backend version is not supported to design database diagrams or tables
  22. Split string and take last element
  23. Can I set ignore_dup_key on for a primary key?
  24. SQL Server replace, remove all after certain character
  25. Inserting rows into a table with one IDENTITY column only [duplicate]
  26. How do I add a auto_increment primary key in SQL Server database?
  27. How to retrieve field names from temporary table (SQL Server 2008)
  28. When using GETDATE() in many places, is it better to use a variable?
  29. Cumulative Total in MS Sql server [duplicate]
  30. Export table data from one SQL Server to another

Leave a Comment