M-oboegaki

日時の取得方法

SELECT CURRENT_TIMESTAMP FROM DUAL
で日時を取得できる。

CURRENT_TIMESTAMP
—————————————————————————
07-06-14 12:55:17.596593 +09:00

select sysdate from dual;

SYSDATE
——–
07-06-21

select to_char(sysdate,’YYYYMMDD’) from dual;

TO_CHAR(
——–
20070621

select to_char(sysdate,’hh24:mi:ss’) from dual;

TO_CHAR(
——–
09:36:47

This entry was posted on 水曜日, 7 月 18th, 2007 at 17:21:18 and is filed under ORACLE. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.