[JLDoty]

The time stamps that are being recorded with the comments appear to be the time at the location of my server, not my local time. Is there any way to make them the local time for whoever is viewing my site?

I do have the correct time zone set in Settings->System.

[Steven]

Did you have the correct time zone set when you posted the comments?

[JLDoty]

Yes. In Settings->System the time zone is set to "US/Pacific". And to double-check I just tried again, posted at 12:05 PM, but it shows up in the comments as posting at 3:05 PM, which is where my server is located.

[Steven]

Okay. If you preview a comment, does the time show correctly in the preview?

[JLDoty]

Yes. More specifically:
1. If I post a comment it shows the wrong time.
2. If I preview a comment, it shows the correct time while previewing, and when I then post it, it shows the wrong time.

[Steven]

Okay, so your database server is at a different location to your web server.

Commentics already has a piece of code to deal with this:

PHP Code:

<?php 

@mysql_query("SET time_zone = " . $cmtx_settings->time_zone); //set time zone DB 

[JLDoty]

A value of '-7:00' worked nicely.

Of course, that is California's offset from GMT now that we're on daylight savings time. In November, when we go back to standard time, does that mean I'll have to go in and reset this value to '-8:00'?

BTW, thanks for all your help.

[Steven]

You might try this:

PHP Code:

<?php 

@date_default_timezone_set($cmtx_settings->time_zone); //set time zone PHP

$dst = date('I'); //this will be 1 in DST or else 0

if ($dst) {

@mysql_query("SET time_zone = '-7:00'"); //set time zone DB (DST)

} else {

@mysql_query("SET time_zone = '-8:00'"); //set time zone DB (not DST)

} 

[JLDoty]

That appears to work nicely. Thanks.