|
|
Posted by bill on 10/20/07 11:01
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.
Navigation:
[Reply to this message]
|