"함수 number format()"의 두 판 사이의 차이

잔글 (봇: 자동으로 텍스트 교체 (-source +syntaxhighlight))
 
(다른 사용자 한 명의 중간 판 9개는 보이지 않습니다)
6번째 줄: 6번째 줄:
[[분류: Java]]
[[분류: Java]]
{{참고|Java number_format()}}
{{참고|Java number_format()}}
<source lang='java'>
<syntaxhighlight lang='java'>
import java.math.BigDecimal;
import java.math.BigDecimal;
public class MyClass {
public class MyClass {
     public static void main(String args[]) {
     public static void main(String args[]) {
         double r = 1234.5678;
         double r = 1234.5678;
         System.out.println(new BigDecimal(r).setScale(2,BigDecimal.ROUND_DOWN));
         System.out.println(new BigDecimal(r).setScale(2,BigDecimal.ROUND_HALF_UP));
         System.out.println(BigDecimal.valueOf(r).setScale(2,BigDecimal.ROUND_DOWN));
         System.out.println(BigDecimal.valueOf(r).setScale(2,BigDecimal.ROUND_HALF_UP));
         System.out.println(new BigDecimal(r).setScale(2,BigDecimal.ROUND_FLOOR));
        // 1234.57
         System.out.println(BigDecimal.valueOf(r).setScale(2,BigDecimal.ROUND_FLOOR));
        // 1234.57
         // 1234.56
         System.out.println(new BigDecimal(r).setScale(6,BigDecimal.ROUND_HALF_UP));
        // 1234.56
         System.out.println(BigDecimal.valueOf(r).setScale(6,BigDecimal.ROUND_HALF_UP));
        // 1234.56
         // 1234.567800
         // 1234.56
         // 1234.567800
     }
     }
}
}
</source>
</syntaxhighlight>
<syntaxhighlight lang='java'>
public class MyClass {
    public static void main(String args[]) {
        double r = 1234.5678;
        System.out.println(new java.math.BigDecimal(r).setScale(2,java.math.BigDecimal.ROUND_HALF_UP));
        System.out.println(java.math.BigDecimal.valueOf(r).setScale(2,java.math.BigDecimal.ROUND_HALF_UP));
        // 1234.57
        // 1234.57
        System.out.println(new java.math.BigDecimal(r).setScale(6,java.math.BigDecimal.ROUND_HALF_UP));
        System.out.println(java.math.BigDecimal.valueOf(r).setScale(6,java.math.BigDecimal.ROUND_HALF_UP));
        // 1234.567800
        // 1234.567800
    }
}
</syntaxhighlight>


==PHP==
==PHP==
[[분류: PHP]]
[[분류: PHP]]
{{참고|PHP number_format()}}
{{참고|PHP number_format()}}
<source lang='php'>
<syntaxhighlight lang='php'>
<?php
<?php
$num = 1234.5678;
$num = 1234.5678;
39번째 줄: 54번째 줄:
echo number_format($num,6);
echo number_format($num,6);
# 1,234.567800
# 1,234.567800
</source>
</syntaxhighlight>
 
==SQL==
[[분류: SQL]]
===MySQL===
[[분류: MySQL]]
{{참고|MySQL FORMAT()}}
<syntaxhighlight lang='mysql'>
SELECT FORMAT(1234.5678, 0);
# 1,235
</syntaxhighlight>
<syntaxhighlight lang='mysql'>
SELECT FORMAT(1234.5678, 2);
# 1,234.57
</syntaxhighlight>
<syntaxhighlight lang='mysql'>
SELECT FORMAT(1234.5678, 6);
# 1,234.567800
</syntaxhighlight>


==같이 보기==
==같이 보기==
* [[함수 floor()]]
* [[함수 floor()]]
* [[함수 round()]]
* [[함수 round()]]
* [[함수 toFixed()]]
* [[함수 thousand_format()]]
* [[함수 thousand_format()]]

2020년 11월 2일 (월) 02:36 기준 최신판

1 개요[ | ]

함수 number_format()

2 Java[ | ]

import java.math.BigDecimal;
public class MyClass {
    public static void main(String args[]) {
        double r = 1234.5678;
        System.out.println(new BigDecimal(r).setScale(2,BigDecimal.ROUND_HALF_UP));
        System.out.println(BigDecimal.valueOf(r).setScale(2,BigDecimal.ROUND_HALF_UP));
        // 1234.57
        // 1234.57
        System.out.println(new BigDecimal(r).setScale(6,BigDecimal.ROUND_HALF_UP));
        System.out.println(BigDecimal.valueOf(r).setScale(6,BigDecimal.ROUND_HALF_UP));
        // 1234.567800
        // 1234.567800
    }
}
public class MyClass {
    public static void main(String args[]) {
        double r = 1234.5678;
        System.out.println(new java.math.BigDecimal(r).setScale(2,java.math.BigDecimal.ROUND_HALF_UP));
        System.out.println(java.math.BigDecimal.valueOf(r).setScale(2,java.math.BigDecimal.ROUND_HALF_UP));
        // 1234.57
        // 1234.57
        System.out.println(new java.math.BigDecimal(r).setScale(6,java.math.BigDecimal.ROUND_HALF_UP));
        System.out.println(java.math.BigDecimal.valueOf(r).setScale(6,java.math.BigDecimal.ROUND_HALF_UP));
        // 1234.567800
        // 1234.567800
    }
}

3 PHP[ | ]

<?php
$num = 1234.5678;
echo number_format($num);
# 1,235
echo number_format($num,2);
# 1,234.57
echo number_format($num,2,'','');
# 123457
echo number_format($num,2,'.','');
# 1234.57
echo number_format($num,6);
# 1,234.567800

4 SQL[ | ]

4.1 MySQL[ | ]

SELECT FORMAT(1234.5678, 0);
# 1,235
SELECT FORMAT(1234.5678, 2);
# 1,234.57
SELECT FORMAT(1234.5678, 6);
# 1,234.567800

5 같이 보기[ | ]

문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}