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 between them and pst*3600

>2.) we have users ALL OVER the world - is there a place to find all
>of the timezones at?

good luck, there's tons and some of them are wacky or don't honor
daylight saving time.

>
>--Joe
>
>On Mon, Apr 30, 2001 at 12:11:55PM -0700, Mark Maggelet wrote:
>> 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 timestamp for say 9:00am when in reality it was entered
>>at
>> >12:00noon
>> >in MI. I have 2 character timezones for all my users so it should
>>be
>> >easy to
>> >convert the two.
>>
>> you could use gmmktime() instead and add or subtract the offset.
>>
>> $offsets=array("
>> "PST"=>1000,  // not actual values
>> "EST"=>-2000,
>> ");
>>
>> $localtime=gmmktime()+$offsets[$timezone];
>>
>> >putenv() won't work because of the fact that the timestamp
created
>> >will be
>> >9:00 no matter what timezone you put it in. So what needs to be
>>done
>> >is some
>> >recognition that 10800 seconds needs to be added to adjust the
PST
>> >timestamp
>> >to an EST timestamp. Are there any functions out ther that do
>>this?
>> >
>> >--Joe
>> >
>> >Joe Stump <[EMAIL PROTECTED]>
>>
>------------------------------------------------------------------
>>---
>>
>> >---
>> >One is taught by experience to put a premium on those
>> >few people who can appreciate you for what you are.
>> >
>> >
>> >--
>> >PHP General Mailing List (http://www.php.net/)
>> >To unsubscribe, e-mail: [EMAIL PROTECTED]
>> >For additional commands, e-mail: [EMAIL PROTECTED]
>> >To contact the list administrators, e-mail: php-list-
>> >[EMAIL PROTECTED]
>>
>
>Joe Stump <[EMAIL PROTECTED]>
>---------------------------------------------------------------------

>---
>Dyslexics of the world
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: php-list-
>[EMAIL PROTECTED]



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to