[BUG] Convert date/time in [metadata].[run] to PST #177
Description
Describe the bug
When a new row is added to [metadata].[run], we track the start time of the run, and sometimes even the end time of the run depending on if it was finished or not. this date/time is based on the local time of the computer, which means when running on the AVD, the times look weird. The AVD uses UTC time, while we use PST time
To Reproduce
Trigger a run on the AVD and you will see that the column [start_date] shows the UTC time, or the time displayed in the AVD
Expected behavior
Just for consistency sake, all date/time should use the same timezone
Potential resolution
Ideally, this would mean all date/time are done in PST, but I could also be convinced to switch all date/time to UTC