MySQL -> PostgreSQL (MySQL을 PostgreSQL로 변환)
MysqlPostgresqlifnull(컴럼명)coalesce(컬럼명)DATE_FORMAT(NOW(), '%Y%m%d%H%i%s')to_char(now(), 'yyyymmddhh24miss')DATE_FORMAT(t1.col, '%Y-%m-%d')concat(substring(t1.col,1,4),'-',substring(t1.col,5,2), '-', substring(t1.col,7,2))DATE_FORMAT(now(), '%Y%m%d')to_char(now(), 'yyyymmdd')LIMIT ${startNo}, ${pageSize}limit ${pageSize} offset ${startNo}trs_dd = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 MONTH),'%Y..
2024. 7. 19.
