Post reply

DateTime Precision

  • 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

  • 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

  • March 30, 2004 at 2:59 pm

    #501191

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

    Thanks anyway.

    Dave

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply