Interesting. If I issue ? CAST(8E9 As I) it displays a negative 9 digit number (-589934592). Also, I thought the limit for 32 bit integers was about 2E9.
Laurie On 29 July 2015 at 13:42, Jean MAURICE <[email protected]> wrote: > Hi Laurie, > I do think that BITRSHIFT is a lot quicker than /2. BITRSHIFT can be done > with only one machine cycle (clock tic); the division is a lot more complex. > > BUT ! > this is true only if K is an integer (k = CAST(8E9 AS integer)). Otherwise > you must add add the conversion time between numeric and integer. > > You can also add a third test : k * .5 sould be faster than k /2 > > The Foxil > Old enough to know how microprocessors work ! > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/camvtr9c9ba8oot9vkwy58bka4rtlvvyz8-gb0aeaenu94mm...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
