Re: Sensibly accounting for timezone differences?
| From: | Joshua Moore-Oliva | Date: | Mon, 17 Mar 2003 18:48:00 +0000 |
| Subject: | Re: Sensibly accounting for timezone differences? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-139994@lists.php.net to get a copy of this message | ||
On March 17, 2003 07:55 am, M Wells wrote:
> Hi All,
>
> I'm an Australian PHP developer and host most of my web sites on US
> servers. One in particular is primarily accessed by Australian visitors
> and I want to be able to reflect Australian Eastern Standard Times when
> writing / reporting records, rather than the server time, which is set
> to US Eastern Standard Time.
>
> I'm wondering if anyone can tell me if there is a sensible way to do
> this easily?
>
> Many thanks in advance!
>
> Regards and best wishes,
>
> Murray Wells,
> Urban Legend Web Design (ABN 18 635 979 727)
I use postgres as my database and it has very very nice built-in datetime
functions to the tune
timestamp now() AT TIME ZONE interval '-5 hours'
or
timestamp now() AT TIME ZONE 'EST'
Josh.