corrected all valid times to be in utc, rather than whatever time zone the database was set to