select -1234599 aa, Ceil(Round((COALESCE(-1234599,0) * 0.1), 1)) am from rdb$database


아폴론 님이 쓰신 글 :
: 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 가 나오게 할수 있을까요?