목록날짜 포맷 변환 (1)

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), '-',..
⑨ 직무역량강화/DB2 2009. 8. 10. 23:00
Prev 1 Next