Untitled

mail@pastecode.io avatar
unknown
plain_text
2 months ago
313 B
3
Indexable
Never
		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 = ?;";
Leave a Comment