|
|
Posted by bill on 10/20/07 11:03
bill wrote:
> On Oct 14, 3:10 pm, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
>> On Sun, 14 Oct 2007 20:54:40 +0200, bill <nob...@spamcop.net> wrote:
>>> I am using the MySQL date and time functions and they save a lot of my
>>> time. But the server is located in a time zone 2 hours away. I read in
>>> the SQL docs how to set the timezone on a per-connection basis, but how
>>> would I do that from PHP ?
>> Untested:
>> mysql_query('SET time_zone = timezone_name');
>
> tested mysql_query('SET time_zone = US/Eastern');
> result: no error, no change at all.
> datetime is still two hours off.
>
correction, time is still one hour off - no change.
(it is too early to read an analog clock)
bill
Navigation:
[Reply to this message]
|