I have a table in format:
Id: int, amount: float, true_date: chararray, time:chararray,
Fortunately, there are only two states in my db.
So if I have a state as “CA” then add +1 to datetime
If state is “MA”, then add +5 to datetime
And then save the results.
Also a corner case..
While adding.. If due to addition the date changes.. then I have to add +1
to true_date as well..