Last post May 05, 2012 07:34 PM by JonnyBravoII
May 05, 2012 03:32 PM|JonnyBravoII|LINK
I'm losing fidelity in a computed column and I'm not sure what is causing it. I have two datetime columns and my computed column is the difference between them in hours.
When I change the 'outTime' value minute by minute, the computed value changes every 5 or 6 minutes i.e. .90625, .90625, .90625, .90625 .90625, .8125, .8125......
Should I make the conversion as a decimal instead?
May 05, 2012 04:05 PM|limno|LINK
You can use the builtin datediff function to return an integer for example:
TABLE yourtable ADD
can change the unit from minute to second or day at your choice.
May 05, 2012 07:34 PM|JonnyBravoII|LINK
Worked like a champ. Thanks much.