[GENERAL] Clients in different Time Zones

From: "Gary MacMinn" <G(dot)MacMinn(at)nca(dot)gov(dot)au>
To: pgsql-general(at)postgreSQL(dot)org
Subject: [GENERAL] Clients in different Time Zones
Date: 1999-12-14 00:18:41
Message-ID: s85627d6.018@syd_aux.nca.gov.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I have written a small help desk database using pgsql, Linux, apache and PHP3 to generate HTML pages. The system in itself works well but I have staff from four different time zones using the system.

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).

Is there any way that these fields could be primed with a time and date, taking the client's local time zone or local system time into account so that they see their local time instead of my server time?

TIA,

Gary MacMinn

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcos Hernandez 1999-12-14 00:21:12 subscribe
Previous Message pawel 1999-12-13 23:39:30 Precompilation error (ecpg)