set db back to local mysql, made end time ISO8601 pacific timezone with '-08'