DB별 함수 비교

isnull => DB2 COALESCE

strcat = > || 로 묶기

 

 

MySQL:
— Convert the current date to YYYYMM format
  SELECT DATE_FORMAT(NOW(), ‘%Y%m’);

DB2:
— Convert the current date to YYYYMM format
  SELECT VARCHAR_FORMAT(CURRENT_DATE, ‘YYYYMM’) FROM sysibm.sysdummy1;