DATE型の操作

• DATE型の追加

 UPDATE [TABLE_NAME] 
 SET [COLUMN_DATE] = TO_DATE( '2007/08/14 18:00:00', 'YYYY/MM/DD HH24:MI:SS' );

• DATE型の表示

 SELECT RES_DATE FROM [TABLE_NAME];

[COLUMN_DATE]

07-08-14

• DATE型の日時の明示的な表示

 SELECT TO_CHAR( [COLUMN_DATE], 'yyyy/mm/dd hh24:mi:ss' ) FROM [TABLE_NAME];

[COLUMN_DATE]

2007/08/14 18:00:00

• DATE型の条件指定

 SELECT TO_CHAR( [COLUMN_DATE], 'yyyy/mm/dd hh24:mi:ss' ) FROM [TABLE_NAME]
 WHERE [COLUMN_DATE] = TO_DATE( '2007/08/14 18:00:00', 'yyyy:mm:dd hh24:mi:ss' );

[COLUMN_DATE]

2007/08/14 18:00:00

---

2010-07-26

---