Viewing 15 posts - 1,516 through 1,530 (of 3,543 total)
erm! did you not state that
1/3 is
(int) 1 divided by (int) 3
however:-
1.0 divided by 3.0 as (money + implied zeros) = 0.3333(0)
select cast(1.0 / 3.0 as money)
1.0 divided by...
June 28, 2007 at 6:19 am
OK for the last time
1 divided by 3 as (money + implied zeros) = 0.0000(0)
1 divided by 3 as (decimal(12,6) + implied zeros) = 0.000000(0)
0.0000(0) - 0.000000(0) = 0.000000(0) =...
June 28, 2007 at 3:49 am
![]() | David Burrows was struggling to prove his point about "implied zeros" fut (sic) he failed. |
No I did not...
June 28, 2007 at 2:45 am
Quite right, well put
June 28, 2007 at 2:45 am
But it was your statement that decimal 0.3333 is not equal to 1/3 and cannot represent 1/3 for BR purposes.
Not mine
So, what is your...
June 27, 2007 at 4:41 pm
I thought we had settled this, that as you can't.
Because 1/3 = 0 as you stated before, it is an expression, that is evaluated to (int) 1 / (int) 3
to get...
June 27, 2007 at 3:54 pm
![]() | X.XX50 value represents values X.XX50(0) .. X.XX50(9) |
Sergiy,
Surely if TR is to produce a value X.XX50 then the...
June 27, 2007 at 3:20 pm
Depends
could be
0x0000000003000000
or
0x0100000003000000
or
0x555555555555D53F
btw who's Davis ?
now you answer my question
June 26, 2007 at 7:27 am
Sergiy,
You go to your local store and purchase an item priced at 33 cents (marked as 0.33)
You give the item to the storekeeper plus 1 dollar
The storekeeper writes down on...
June 26, 2007 at 2:13 am
1 divided by 3
As an integer (yes I know as zero as you keep on stating)
or
As a decimal number with a number of decimal places to a certain accuracy within the...
June 25, 2007 at 3:01 pm
1/3 - 1/3 = 0
Right?
Hope you not gonna deny this.
No and I never did. I only stated
0.33 - 0.333333 = -0.003333
and
0.33 - 0.333333 <> 0
June 25, 2007 at 6:47 am
Did you see the script?
Yes
Did you understand it?
Yes
I have never assigned 0.33 or 0.3333333 to any variable.
Yes you did, you assigned the rounded result of the division to the variables
SET...
June 24, 2007 at 8:58 am
wow you showed that .33 minus .333333 equals -.003333 and -.003333 rounded to 2 decimal places equals .00
I could have done that, but what has that got to do with...
June 24, 2007 at 7:29 am
Can you give any reference to any math rule which implies those zeros?
No.
But if 1.23 expressed to 6 decimal places is 1.230000, then, if the trailing zeros are not implied...
June 24, 2007 at 6:44 am
It says if ALL following digits are zeros.
The following zeroes are implied
1.23 is 1.23, trailing zeroes are implied but not shown
Problem is you don't know the ALL following digits.
You can...
June 24, 2007 at 4:21 am
Viewing 15 posts - 1,516 through 1,530 (of 3,543 total)