Notice
Recent Posts
Recent Comments
Gentle Breeze
[DB2] 날짜 포맷 변환표 본문
▶ 날짜 포멧 변환표
'YYYY.MM.DD'
REPLACE(CHAR(DATE(date_exp),ISO), '-', '.')
'HH:MI:SS'
CHAR(TIME(date_exp) , JIS )
'YYYY/MM/DD'
REPLACE(CHAR(DATE(date_exp), ISO), '-', '/')
'YYYYMMDD'
CHAR(DATE(date_exp))
'HH24:MI:SS'
CHAR(TIME(date_exp) )
'YYYY.MM.DD HH24:MI'
REPLACE(CHAR(DATE(date_exp), ISO), '-', '.')
|| CAST( TIME(date_exp) AS CHAR(5))
'YYYY/MM/DD HH24:MI:SS'
REPLACE(CHAR(DATE(date_exp), ISO), '-', '/')
|| CAST( TIME(date_exp))
'YYYY.MM.DD'
REPLACE(CHAR(DATE(date_exp),ISO), '-', '.')
'HH:MI:SS'
CHAR(TIME(date_exp) , JIS )
'YYYY/MM/DD'
REPLACE(CHAR(DATE(date_exp), ISO), '-', '/')
'YYYYMMDD'
CHAR(DATE(date_exp))
'HH24:MI:SS'
CHAR(TIME(date_exp) )
'YYYY.MM.DD HH24:MI'
REPLACE(CHAR(DATE(date_exp), ISO), '-', '.')
|| CAST( TIME(date_exp) AS CHAR(5))
'YYYY/MM/DD HH24:MI:SS'
REPLACE(CHAR(DATE(date_exp), ISO), '-', '/')
|| CAST( TIME(date_exp))
'⑨ 직무역량강화 > DB2' 카테고리의 다른 글
[DB2] Simple DB2 Functions (0) | 2009.08.10 |
---|---|
[DB2] DIGITS() Function (0) | 2009.08.05 |
[DB2] SQL Codes (0) | 2009.07.31 |
Comments