Is there a way to offset the time in a SQL query?

The SQL Server is on a shared server where the time is set to UTC.

The Joomla Server Time is "America/Los_Angeles"

I am charting a count of articles posted on a date but since there is an 8 hour offset between UTC and America/Los_Angeles, my charts are not in sync.

Here is my current SQL Query:
SELECT
DATE_FORMAT(created,'%a-%d') as CREATED, count(created) as Date
FROM #__content
WHERE CatId = 15
AND created >= curdate() - interval 6 day
GROUP BY date(created);

Hello,

See CONVERT_TZ MySQL function.

Regards,
ARI Soft