개인적인 정리

ORACLE CURRENT_DATE() 본문

DB/ORACLE

ORACLE CURRENT_DATE()

yeon.Biju 2020. 3. 26. 10:41

오라클 CURRENT_DATE()

 

CURRENT_DATE returns the current date in the session time zone, in a value in the Gregorian calendar of data type DATE.

 

 

SQL > SELECT SESSIONTIMEZONE, CURRENT_DATE FROM DUAL ;

--> +09:00          2020/03/26 오전 10:40:48

 

'DB > ORACLE' 카테고리의 다른 글

ORACLE DENSE_RANK()  (0) 2020.03.26
ORACLE DELETEXML()  (0) 2020.03.26
ORACLE DECODE()  (0) 2020.03.26
ORACLE CURRENT_TIMESTAMP()  (0) 2020.03.26
ORACLE COUNT()  (0) 2020.03.26
ORACLE COS()  (0) 2020.03.26
ORACLE CONCAT()  (0) 2020.03.25
ORACLE COLLECT()  (0) 2020.03.25
Comments