Subject Re: [firebird-support] SQL: clear the least signifcant bits in a 64 bit integer
Author Hannes Streicher
Post date 2005-12-14T09:45:38Z
Guten Tag Si Carter,

am Mittwoch, 14. Dezember 2005 um 10:24 schrieben Sie:


>> -----Original Message-----
>> I have a 64 bit integer and I need to zero out the least significant
>> 32 bits and use the resulting value. How do I do this in firebird ?

> You will probably need to create a UDF.

Why ?
Integer Divide and Multiply

select (1000 / 64 ) *64 from table ;

substitue 64 with the Value of 2^32+1





--
Mit freundlichen GrĂ¼ssen
Hannes Streicher mailto:HStreicher@...