develog

[Oracle] timestamp to date 본문

DB/Oracle

[Oracle] timestamp to date

냐옴 2017. 4. 3. 10:37

SELECT CAST(SYSTIMESTAMP AS DATE)
FROM DUAL

저작자표시

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

[Oracle] insert all  (0) 2017.04.13
[Oracle] total_sec 을 hh:mm:ss 로 변환  (0) 2017.04.04
[Oracle] Function return table  (0) 2017.03.27
[Oracle] 참조 찾기  (0) 2017.03.27
[Oracle] TIMESTAMP, INTERVAL  (0) 2016.12.01
'DB/Oracle' Related Articles more
Comments