I have a cell stored in the database in UTC timezone. I need to convert them to PST so the output will match with current local time. I don't want to mess around with the database settings, php.ini or any server configuration. I have searched many examples but none of them give me a simple solution.

I installed RokComments plugin for Joomla! so visitors can post comments about my article. On every comments that user posted, I received an email from IntenseDebate (the comment platform I used) which contains a link to my article. However, the link in the email always point to https:// URL instead of http://. I don't have SSL installed so that link will bring me to error page.