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