DateTime Precision

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  March 30, 2004 at 12:31 pm

  #101941

  I have client who is in a time critical business where we need to record times to 6 decimal places and then perform time related arithmetic.

  Does anyone know if you can increase the precision of the DATETIME datatype beyond milli-seconds?

  Does ayone have any other ideas on how to do this as date time arithmetic can get quite nasty and i would prefer to use functions which i know work instead of having to write them myself.

  Ta

  Dave

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  March 30, 2004 at 1:41 pm

  #501163

  You cannot change the way DATETIME datatype is stored. It's not stored as a date and/or time. It's eight-bytes, with the first four-bytes the number of days after or before the default date. And four-bytes as the number of 'ticks' (.333 milliseconds) after midnight.

  -SQLBill

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  March 30, 2004 at 2:59 pm

  #501191

  Oh well. I'd better go and use Informix or Oracle then.

  Thanks anyway.

  Dave