How to insert System Date
INSERT
String inserSql = "Insert into PROMO_FILTER_CX_INFO (MOBILE, STATUS,REQUEST_DATE) Values (?, ?,SYSDATE)";
jdbcTemplate.update(inserSql,addCampaignBlackListCxRq.getMobileNo(),"OFF");
UPDATE
String updateSql = "UPDATE PROMO_FILTER_CX_INFO pfci SET pfci.STATUS = 'OFF',pfci.REQUEST_DATE = SYSDATE WHERE pfci.MOBILE=? ";
jdbcTemplate.update(updateSql,addCampaignBlackListCxRq.getMobileNo());
INSERT
String inserSql = "Insert into PROMO_FILTER_CX_INFO (MOBILE, STATUS,REQUEST_DATE) Values (?, ?,SYSDATE)";
jdbcTemplate.update(inserSql,addCampaignBlackListCxRq.getMobileNo(),"OFF");
UPDATE
String updateSql = "UPDATE PROMO_FILTER_CX_INFO pfci SET pfci.STATUS = 'OFF',pfci.REQUEST_DATE = SYSDATE WHERE pfci.MOBILE=? ";
jdbcTemplate.update(updateSql,addCampaignBlackListCxRq.getMobileNo());
No comments:
Post a Comment