CASE
WHEN LEAVESQTY = 0 THEN '0.0'
WHEN LEAVESQTY = TRUNC(LEAVESQTY) THEN TO_CHAR(LEAVESQTY) || '.0'
ELSE TO_CHAR(LEAVESQTY)
END || '~'
Query Filter
Posted on
trunc
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)