After my last week's email on timezones I have come to the decision that it
is far more sensible to cease using fixed offsets from UTC (e.g. +2:00) and
to use the proper zones e.g. "Europe/London".
After doing some reading up on the subject as I am not too familiar with it,
I understand that it i
Thank you!
I think this is what I needed.
Regards,
Venelin
Robin Vickery wrote:
On Mon, 22 Nov 2004 11:52:03 -0500, Gryffyn, Trevor
<[EMAIL PROTECTED]> wrote:
Then somewhere there has to be a cross reference between name and
timezone info. I'm sorry I'm not running Apache here and don't have
ac
On Mon, 22 Nov 2004 11:52:03 -0500, Gryffyn, Trevor
<[EMAIL PROTECTED]> wrote:
> Then somewhere there has to be a cross reference between name and
> timezone info. I'm sorry I'm not running Apache here and don't have
> access to the same info that you're using, but I'd try digging into
> those con
didn't even consider the whole alphabetical thing, I should have
noticed.
Good luck!
-TG
> -Original Message-
> From: Venelin Arnaudov [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 22, 2004 11:24 AM
> To: Gryffyn, Trevor
> Subject: Re: [PHP] Timezones
>
&
On Fri, 19 Nov 2004 12:56:55 +0100, Venelin Arnaudov <[EMAIL PROTECTED]> wrote:
> I have a legacy PHP3 system and a MySQL DB with two tables:
> [...]
> When a user submits a message, my PHP script (using time() function)
> stores the submission time in messages.date field. However this value is
> n
fset for you.
Let us know what you end up doing.
-TG
-Original Message-
From: Venelin Arnaudov [mailto:[EMAIL PROTECTED]
Sent: Friday, November 19, 2004 6:57 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Timezones
Hi,
I have a legacy PHP3 system and a MySQL DB with two tables:
user {
user_id in
; To: [EMAIL PROTECTED]
> Subject: [PHP] Timezones
>
>
> Hi,
>
> I have a legacy PHP3 system and a MySQL DB with two tables:
> user {
> user_id int,
> timezone varchar (like "Europe/Brussels", "US/Eastern",
> "America/New_York
Hi,
I have a legacy PHP3 system and a MySQL DB with two tables:
user {
user_id int,
timezone varchar (like "Europe/Brussels", "US/Eastern",
"America/New_York", etc.)
}
and
messages {
msg_id int,
user_id int,
date int
}
When a user submits a message, my PHP script (using time() function)
sto
Hi,
Friday, September 26, 2003, 2:55:51 AM, you wrote:
JJ> Got a client site in Thailand that is about 13 hours
JJ> different from the Web Server time so with any
JJ> date/time stamping I need to add the 13 hours.
JJ> However, when it comes time for DST, I'd hate to have
JJ> to code for that or r
They want everything set to their time, so it would
probably be easier just to determine the server time
and add as necessary. I think...
--- Jeff McKeon <[EMAIL PROTECTED]> wrote:
> What if you set the server to use UTC and then used
> the clients local
> system setting to offset it for each cl
just a logic suggestion, I have no idea if it's possible with
code but I would imagin it would be..
Jeff
> -Original Message-
> From: J J [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 25, 2003 12:56 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Timezones
Got a client site in Thailand that is about 13 hours
different from the Web Server time so with any
date/time stamping I need to add the 13 hours.
However, when it comes time for DST, I'd hate to have
to code for that or remember to manually change the
time stamping.
Is there some kind of automat
If you want to do it correctly it is much more difficult to calculate
the TZ than you think. The problem is that different time zones shift
to daylight savings at different times and some do not shift at all.
Therefore simply adding the offset will work for a while and then you
will get problems i
On Mon, 30 Apr 2001 14:24:20 -0500, Joe Stump ([EMAIL PROTECTED])
wrote:
>Thanks to everyone who sent in the info. The problem is as follows:
>
>1.) the mktime()'s are stored as PST in the DB.
they still could be just make your pst offset be 0 and every timezone
offset be the difference in hours
>; <[EMAIL PROTECTED]>
Sent: Monday, April 30, 2001 3:24 PM
Subject: Re: [PHP] timezones
> Thanks to everyone who sent in the info. The problem is as follows:
>
> 1.) the mktime()'s are stored as PST in the DB.
> 2.) we have users ALL OVER the world - is there a place to fin
Thanks to everyone who sent in the info. The problem is as follows:
1.) the mktime()'s are stored as PST in the DB.
2.) we have users ALL OVER the world - is there a place to find all of the
timezones at?
--Joe
On Mon, Apr 30, 2001 at 12:11:55PM -0700, Mark Maggelet wrote:
> On Mon, 30 Apr
I would use gmktime() to create a UTC timestamp stored in the database, and then use
the knowledge about each users timezone to convert this information when showing it.
- Frank
> I have a quick question regarding timezones ...
>
> On the local side a record is inserted into the DB by someone
time. Like
result = mktime() - EST
Is this what you were talking about?
Jon
- Original Message -
From: "Joe Stump" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 30, 2001 2:56 PM
Subject: [PHP] timezones
> I have a quick question regarding
On Mon, 30 Apr 2001 13:56:20 -0500, Joe Stump ([EMAIL PROTECTED])
wrote:
>I have a quick question regarding timezones ...
>
>On the local side a record is inserted into the DB by someone in
>Michigan, while
>the server rests in CA. Thus a three hour difference. The local
>mktime() will
>create a t
I have a quick question regarding timezones ...
On the local side a record is inserted into the DB by someone in Michigan, while
the server rests in CA. Thus a three hour difference. The local mktime() will
create a timestamp for say 9:00am when in reality it was entered at 12:00noon
in MI. I hav
20 matches
Mail list logo