μ«μν ν¨μ
νν | μ€λͺ
|
---|
ABS(μ«μ) | μ«μμ μ λκ° λ°ν |
CEILING(μ«μ) | μ«μλ₯Ό μ μλ‘ μ¬λ¦Όν΄μ λ°ν |
FLOOR(μ«μ) | μ«μλ₯Ό μ μλ‘ λ΄λ¦Όν΄μ λ°ν |
ROUND(μ«μ, m) | μ«μλ₯Ό μμμ mλ²μ§Έ μ리κΉμ§ λ°μ¬λ¦Όν΄μ λ°ν |
TRUNCATE(μ«μ, m) | μ«μλ₯Ό μμμ mλ²μ§Έ μ리κΉμ§ λ²λ¦Όν΄μ λ°ν |
POWER(μ«μ, m) | μ«μμ mμ κ³± λ°ν |
MOD(μ«μ, m) | μ«μλ₯Ό mμΌλ‘ λλ λλ¨Έμ§ λ°ν |
SELECT
ABS(123456.7),
CEILING(123456.7),
FLOOR(123456.7),
ROUND(123456.7, 2),
TRUNCATE(123456.7, 2),
POWER(123456, 3),
MOD(123456, 4);
![](https://velog.velcdn.com/images/thisk336/post/783b87a8-0ea3-43de-bbc4-fb505e708a89/image.png)
![](https://velog.velcdn.com/images/thisk336/post/18b92525-7779-4877-ae2c-48c87a6bac1f/image.png)
λ μ§ν ν¨μ
νν | μ€λͺ
|
---|
NOW() | νμ¬ λ μ§μ μκ° λ°ν |
CURRENT_DATE() | νμ¬ λ μ§ λ°ν |
CURRENT_TIME() | νμ¬ μκ° λ°ν |
SELECT NOW(), CURRENT_DATE(), CURRENT_TIME();
![](https://velog.velcdn.com/images/thisk336/post/6a90a3d7-eb22-4b06-a8c7-3f28ea73bd69/image.png)