fixed timezone for last_application