The easiest way is to add an additional column with the “local time”. First the affected column as time incl. Define and select the time zone and then create the…