[time-nuts] Precision Date/Time Calculations in MS SQL

Tom Van Baak tvb at LeapSecond.com
Sat Jul 2 13:44:37 UTC 2011


Since we all know "time is money", this will also work. But it's
probably less efficient to store nanoseconds as if they were
cents so I hope no one actually uses that decimal encoding.

> I don't know how many digits are allowed for the "money" type!  <G>
>  http://msdn.microsoft.com/en-us/library/ms187752.aspx
>  http://msdn.microsoft.com/en-us/library/ms190476.aspx
> 
> Hope that helps a bit.
> 
> Cheers,
> David




More information about the time-nuts mailing list