Untitled
Anonymous
plain_text
12/21/2023 10:59 AM
420 B
17
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