From: | Mark Jewiss <Mark(dot)Jewiss(at)knowledge(dot)com> |
---|---|
To: | Gary MacMinn <G(dot)MacMinn(at)nca(dot)gov(dot)au> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Clients in different Time Zones |
Date: | 1999-12-14 11:06:39 |
Message-ID: | Pine.BSO.4.10.9912141103350.24474-100000@office.knowledge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
On Tue, 14 Dec 1999, Gary MacMinn wrote:
> As it stands now, when a new job is entered, the date in and time in
> fields are primed with the current date and time using date("d-M-Y")
> and date("H:i:s", time()). This is fine but it inserts the details
> from the server time zone (fine for me but the others are up to two
> hours off).
Do the different sites run the PHP application from a local server, and
connect to a remote database? If this is the case, one solution is to
change the code in the PHP script so that you set a variable relevant to
the time zone.
You then use this to alter time data you select from tables before
displaying it on screen. It could work by just being an offset in hours
from the database time server.
Or if everyone uses the same script then you could tell by the users login
which site they are in and then change the time accordingly.
Regards,
Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com
From | Date | Subject | |
---|---|---|---|
Next Message | Samy Elashmawy | 1999-12-14 11:14:57 | Re: [GENERAL] Announce: Postgres Access Control Tool |
Previous Message | postgres | 1999-12-14 09:26:47 | Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM? |