Hi,
I have many subscription in the system. When I check the notifications table, I can see targetDate field inside event_json column and effective_date column for one account. Both field's value are same such as; 2021-03-03 05:15:38. Also, when I check the reference_time column in accounts table, I see 2020-07-03 05:15:38 datetime. So, I want to change just time value as 19:15:38 instead of 05:15:38 because I want to next-period automatically runs at new time(19:15:38).
However, although I change reference_time, targetDate and effective_date fields' value in test environment database, my expectation was that future next billing date queue's should be 2021-04-03 19:15:38. But, after automatically run it, new column was inserted to the notifications table with 2021-04-03 05:15:38. It looked like not to change anything about future's billing date hour.
What should I do to have the future billing date assigned with the new time(2021-04-03 19:15:38)?
Regards,
Thank you.