Search

λ‚ μ§œν•¨μˆ˜

λ‚ μ§œν•¨μˆ˜

SYSDATE
ν˜„μž¬ λ‚ μ§œμ™€ μ‹œκ°„μ„ DATE νƒ€μž…μ˜ λ°μ΄ν„°λ‘œ λ°˜ν™˜ν•˜λŠ” ν•¨μˆ˜
SYSTIMESTAMP
ν˜„μž¬ λ‚ μ§œμ™€ μ‹œκ°„μ„ TIMESTAMP νƒ€μž…μ˜ λ°μ΄ν„°λ‘œ λ°˜ν™˜ν•˜λŠ” ν•¨μˆ˜
ADD_MONTHS(λ‚ μ§œ, κ°œμ›”μˆ˜)
ν•΄λ‹Ή λ‚ μ§œλ‘œλΆ€ν„° κ°œμ›” 수λ₯Ό λ”ν•œ λ‚ μ§œλ₯Ό λ°˜ν™˜ν•˜λŠ” ν•¨μˆ˜
MONTHS_BETWEEN(λ‚ μ§œ1, λ‚ μ§œ2)
λ‚ μ§œ1 λΆ€ν„° λ‚ μ§œ2 μ‚¬μ΄μ˜ κ°œμ›” 수λ₯Ό λ°˜ν™˜ν•˜λŠ” ν•¨μˆ˜
NEXT_DAY(λ‚ μ§œ, μš”μΌλ²ˆν˜Έ)
μ§€μ •ν•œ λ‚ μ§œ 이후에 λ‚˜μ˜€λŠ” μš”μΌλ²ˆν˜Έμ— ν•΄λ‹Ήν•˜λŠ” λ‚ μ§œλ₯Ό λ°˜ν™˜ν•˜λŠ” ν•¨μˆ˜ - μš”μΌ 번호 : μΌμš”μΌ(1) ~ ν† μš”μΌ(7)
LAST_DAY(λ‚ μ§œ)
μ§€μ •ν•œ λ‚ μ§œμ™€ 같은 λ‹¬μ˜ λ§ˆμ§€λ§‰ λ‚ μ§œλ₯Ό λ°˜ν™˜ν•˜λŠ” ν•¨μˆ˜ (월말)
TRUNC( λ‚ μ§œ, λ‚ μ§œν˜•μ‹ )
λ‚ μ§œν˜•μ‹ λ‹¨μœ„λ‘œ λ‚ μ§œ 데이터λ₯Ό μ ˆμ‚­ν•˜μ—¬ λ°˜ν™˜ν•˜λŠ” ν•¨μˆ˜ ex) TRUNC( λ‚ μ§œ, 'MM' ) : μ›” λ‹¨μœ„λ‘œ λ‚ μ§œ 데이터λ₯Ό μ ˆμ‚­ν•˜μ—¬ 같은 λ‹¬μ˜ 첫번째 λ‚ μ§œλ₯Ό κ΅¬ν•˜λŠ” ν•¨μˆ˜ (μ›”μ΄ˆ)