* 오늘 쓴 글일 경우 시간표현, 어제까지 썼던 글은 날짜로 표현 *
1. DECODE문
select gdate, decode (to_char(gdate, 'yyyymmdd'), to_char(sysdate, 'yyyymmdd'),
to_char(gdate, 'hh24:mi:ss'),
to_char(gdate, 'yyyy-mm-dd')) as list_date
from board
gdate list_date
--------------------------------------
12/01/2006 11:17:53 11:17:53
12/01/2006 13:34:17 13:34:17
12/01/2006 11:18:00 11:18:00
12/01/2006 11:18:07 11:18:07
12/01/2006 11:18:38 11:18:38
12/01/2006 13:33:49 13:33:49
12/01/2006 11:17:25 11:17:25
12/01/2006 11:17:29 11:17:29
12/01/2006 13:33:53 13:33:53
12/01/2006 16:28:31 16:28:31
12/01/2006 15:09:14 15:09:14
12/01/2006 16:27:22 16:27:22
12/01/2006 15:16:31 15:16:31
12/01/2006 16:27:26 16:27:26
11/30/2006 16:44:44 2006-11-30
12/01/2006 16:28:38 16:28:38
--------------------------------------------------------------------------------------
2. CASE문
SELECT gdate, CASE to_char(gdate, 'yyyymmdd')
WHEN to_char(sysdate, 'yyyymmdd') THEN to_char(gdate, 'hh24:mi:ss')
ELSE to_char(gdate, 'yyyy-mm-dd')
END as list_date
FROM board
gdate list_date
-------------------------------------
12/01/2006 11:17:53 11:17:53
12/01/2006 13:34:17 13:34:17
12/01/2006 11:18:00 11:18:00
12/01/2006 11:18:07 11:18:07
12/01/2006 11:18:38 11:18:38
12/01/2006 13:33:49 13:33:49
12/01/2006 11:17:25 11:17:25
12/01/2006 11:17:29 11:17:29
12/01/2006 13:33:53 13:33:53
12/01/2006 16:28:31 16:28:31
12/01/2006 15:09:14 15:09:14
12/01/2006 16:27:22 16:27:22
12/01/2006 15:16:31 15:16:31
12/01/2006 16:27:26 16:27:26
11/30/2006 16:44:44 2006-11-30
12/01/2006 16:28:38 16:28:38
'Server-Side > Oracle' 카테고리의 다른 글
TO_CHAR 옵션. (0) | 2008.03.07 |
---|---|
달력 (0) | 2008.03.07 |
Primary Key 설정하기 (0) | 2006.12.07 |
게시판 리플달기 (0) | 2006.12.01 |
OCIStmtExecute: ORA-01400 (0) | 2006.11.27 |