declare external function Truncate   --절사 함수 등록 2008.05.07
int by descriptor, int by descriptor
returns parameter 2
entry_point 'fbtruncate' module_name 'fbudf';

declare external function i64Truncate
numeric(18) by descriptor, numeric(18) by descriptor
returns parameter 2
entry_point 'fbtruncate' module_name 'fbudf';


select 1234599 aa, Truncate((COALESCE(1234599,0) * 0.1)) am from rdb$database => 123,359
select -1234599 aa, Truncate((COALESCE(-1234599,0) * 0.1)) am from rdb$database => -123,356
select -1234599 aa, i64truncate(COALESCE(-1234599,0) * 0.1) am from rdb$database => -123,356

저기 음수를 어떻게 해야 -123.359 가 나오게 할수 있을까요?