Data Fix - Expiry Date Display Incorrect on PROD

Following NRs have 12:59 am OR 10:59 pm displaying issue affected by day light saving. If we want to correct all of them affected by day light saving, we need to create a ticket to do data fix for requests table and event table. 12:59 am OR 10:59 has been saved in expiration_date in requests table and event_json field in events table. If British Columbia has permanently abolished the biannual time change, we will NOT have any more issue then.

Queries used to retrieve NRs:
select nr_num from requests where id in (select nr_id from events where event_json::text like '%12:59 am%') order by nr_num
select nr_num from requests where id in (select nr_id from events where event_json::text like '%10:59 pm%') order by nr_num

Displaying 12:59 am
NR 0275664
NR 0277366
NR 0287767
NR 0335639
NR 0341092
NR 0345104
NR 0415139
NR 0417627
NR 0436972
NR 0447516
NR 0454105
NR 0479504
NR 0503845
NR 0541241
NR 0643975
NR 0700706
NR 0705986
NR 0726937
NR 0745746
NR 0765877

Displaying 10:59 pm
NR 0273659
NR 0284272
NR 0373097
NR 0373988
NR 0381464
NR 0412247
NR 0417813
NR 0418010
NR 0437516
NR 0452071
NR 0463894
NR 0466259
NR 0488646
NR 0490632
NR 0503568
NR 0530532
NR 0553707
NR 0588882
NR 0591059
NR 0591219