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.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to