Untitled

 avatar
unknown
plain_text
a year ago
313 B
6
Indexable
		String sql = "UPDATE `vehicle_G3` SET PremiumAmt = ?, FromDate = CASE WHEN CURRENT_DATE < ToDate THEN DATE_ADD(ToDate, INTERVAL 1 DAY) ELSE CURRENT_DATE END, ToDate = CASE WHEN CURRENT_DATE < ToDate THEN DATE_ADD(CURRENT_DATE, INTERVAL 1 YEAR) ELSE DATE_ADD(ToDate, INTERVAL 1 YEAR) END, WHERE PolicyNo = ?;";
Editor is loading...
Leave a Comment