by 여리당 [SQL Query] [2019.04.25 15:08:38]
초보적인 질문인데요 숫자끝자리는 0으로 나오게 어떻게 할수있을까요?
예시) 1234->1230
111->110
123->120
간단히 할수있는방법이 있나요?
substr(v, 1, length(v)-1)||0
select substr(a,0,length(a)-1)||0 from ( select '1234' a from dual union all select '111' a from dual union all select '123' a from dual )
TRUNC(숫자, -1)
올림, 반올림, 내림
Oracle : CEIL, ROUND, TRUNC
MySQL, MS-SQL : CEILING, ROUND, FLOOR