Posted by shannonwhitty on 09/28/83 11:49

Please help,

I am running a database on a free server in another country and the
timezone is obviously different. All I want to do is add 15 hours to
the timezome before updating the database (or on update would be
fine!!!)

I can output the current timestamp perfectly as:

echo date("Y-m-d H:i:s");

2006-06-05 07:20:57

But when I try to use the Z function I can't get it to work... There is
very little help or working demos on this anywhere on the internet...

echo date("Y-m-d H:i:s", date("Z +54000"));

1969-12-31 13:00:00

As you can see, this sets the timezone well and truly miles from where
I want it to be...

I can't find an easy way to do it but all I want to do is something
like the following:

UPDATE 'table' SET 'date' = CURRENT TIMESTAMP +15:00

Why can't it be that easy???

BTW I've been programming in PHP for 3 days now so I am quite new so
please go easy...

• Next in forum: Re: date() function - problem changing timezome
• Prev in forum: Re: No value for $requete = mssql_query() ...
• Thread view: date() function - problem changing timezome

[Reply to this message]