๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
๐Ÿง‘‍๐Ÿ’ผ SAP/ABAP

[SAP ABAP] TRUNC ์‚ฌ์šฉ๋ฒ• (๊ธˆ์•ก ์ ˆ์‚ญ ๋ฐฉ๋ฒ•, ์†Œ์ˆ˜์  ๋ฒ„๋ฆผ)

by Jay Din 2023. 12. 4.
728x90
๋ฐ˜์‘ํ˜•

TRUNC ์ด๋ž€

TRUNC( your_number )

` TRUNC ` ์€ ๋ฐ์ดํ„ฐ๋ฅผ ์ž˜๋ผ๋‚ด๋Š” ํ•จ์ˆ˜ ์ค‘ ํ•˜๋‚˜์ž…๋‹ˆ๋‹ค.

` TRUNC  ` ํ•จ์ˆ˜๋Š” ๋‚ ์งœ๋‚˜ ์ˆซ์ž๋ฅผ ๋‹ค๋ฃฐ ๋•Œ ์ฃผ๋กœ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค.

 

` TRUNC ` ํ•จ์ˆ˜๋Š” ์ฃผ์–ด์ง„ ์ˆซ์ž์˜ ์†Œ์ˆ˜๋ฅผ ๋ฒ„๋ฆผ(truncate) ์ฒ˜๋ฆฌํ•ฉ๋‹ˆ๋‹ค.

์ฆ‰, ์†Œ์ˆ˜ ๋ถ€๋ถ„์„ ์ œ๊ฑฐํ•˜๊ณ  ์ •์ˆ˜ ๋ถ€๋ถ„๋งŒ์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.์ด๋Š” ์ฃผ๋กœ ์†Œ์ˆ˜์  ์ดํ•˜์˜ ๊ฐ’์ด ํ•„์š”ํ•˜์ง€ ์•Š์€ ๊ฒฝ์šฐ์— ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค.

 

์‚ฌ์šฉ ์˜ˆ์ œ

DATA: lv_number TYPE p DECIMALS 3,
     lv_truncated TYPE i.

lv_number = '123.456'.
lv_truncated = TRUNC( lv_number ).

WRITE: / 'Original Number:', lv_number,
  / 'Truncated Number:', lv_truncated.

 

์ด ์ฝ”๋“œ์—์„œ ` lv_number ` ๋ณ€์ˆ˜์—๋Š” ์‹ค์ˆ˜๊ฐ’์ธ '123.456'์ด ๋“ค์–ด ์žˆ์Šต๋‹ˆ๋‹ค.

` TRUNC ` ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์ด ๊ฐ’์„ ๋ฒ„๋ฆฌ๋ฉด ` lv_truncated ` ์—๋Š” ์ •์ˆ˜ ๋ถ€๋ถ„์ธ 123๋งŒ ๋‚จ๊ฒŒ ๋ฉ๋‹ˆ๋‹ค.

์‹คํ–‰ํ™”๋ฉด

 

์ด์™€ ๊ฐ™์ด ` TRUNC ` ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด ์†Œ์ˆ˜ ๋ถ€๋ถ„์„ ์ œ๊ฑฐํ•˜์—ฌ ์ •์ˆ˜ ๋ถ€๋ถ„๋งŒ์„ ์–ป์„ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

728x90
๋ฐ˜์‘ํ˜•