오라클 함수, SQL Functions(10g) - Datetime Functions
개발 및 관리/Oracle 9i, 10g, 11g, 12c, 19c 2012. 11. 17. 11:41반응형
http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions001.htm#sthref912
1. ADD_MONTHS
2. CURRENT_DATE
3. CURRENT_TIMESTAMP
4. DBTIMEZONE
5. EXTRACT (datetime)
6. FROM_TZ
7. LAST_DAY
8. LOCALTIMESTAMP
9. MONTHS_BETWEEN
10. NEW_TIME
11. NEXT_DAY
12. ROUND (date)
13. SESSIONTIMEZONE
14. SYSDATE
15. SYSTIMESTAMP
16. TO_CHAR (date)
17. TO_TIMESTAMP
18. TRUNC (date)
19. TZ_OFFSET
반응형
'개발 및 관리 > Oracle 9i, 10g, 11g, 12c, 19c' 카테고리의 다른 글
| 오라클 함수, SQL Functions(10g) - NUL-Related Functions, Environment and Identifier Functions (0) | 2012.11.17 |
|---|---|
| 오라클 함수, SQL Functions(10g) - Collection Functions, Hierarchical Functions (0) | 2012.11.17 |
| 오라클 함수, SQL Functions(10g) - Character Functions (0) | 2012.11.15 |
| 오라클 함수, SQL Functions(10g) - Numeric Functions (0) | 2012.11.15 |
| Oracle Database 10g SQL Fundamentals II - Practice 6 (0) | 2012.11.14 |
