SELECT dc.launch_time, date_add(dc.launch_time,interval dc.effective_time day) FROM tb_discount_coupon as dc