- May 24, 2010
It's kind of so close and yet so far, Charles. The @Days function is wonderful, but it (or something closely similar or possibly a new parameter on the existing @Days function so as not to "break" existing code) could be made even more wonderful by having a way to also have fractions of a day, something like 2.33333333 days, for approximately 8 hours. Now I really don't have a strong notion of how many decimal places to carry the calculations to other than to say that 7 decimal places of precision are probably enough, particularly given the documented 100 ns resolution of NTFS date/time stamps, which, strictly speaking, require only about that level of precision). Alternatively, functions to subtract times could be added, although I'm not sure they would really be necessary if @Days was altered to return fractional days.