반응형
CAST(A.DAILY_FEE*30*(1-B.DISCOUNT_RATE*0.01) AS SIGNED) AS FEE
💡 CAST 연산자
: 계산된 FEE값을 정수로 변환
AS SIGNED : 부호를 유지
AS UNSIGNED : 부호 제거
반응형
CAST(A.DAILY_FEE*30*(1-B.DISCOUNT_RATE*0.01) AS SIGNED) AS FEE
💡 CAST 연산자
: 계산된 FEE값을 정수로 변환
AS SIGNED : 부호를 유지
AS UNSIGNED : 부호 제거