Peter Tilbrook wrote:
>
> I'm in Canberra(ish) Sydney/Canberra/Melbourne time zone. GST+10 basically.
>
> Our host provider is located in the good 'ole US of A.
>
> My question is, programatically, how can I not keep losing at least 24 hours
> when adding/updating content to a database (hosted in US) but for Aussie
> content.
Why would that make you loose content?
> Is there a trick - when hosting in a completely different part of the
> globe - to enfore local date/time?
Does your database have advanced datetime support? I can just specify
the timezone in my queries:
test=> set timezone= 'GMT';
test=> select current_timestamp;
timestamptz
-------------------------------
2003-06-26 12:23:01+00
test=> set timezone= 'EST';
test=> select current_timestamp;
timestamptz
-------------------------------
2003-06-26 07:23:14-05
test=> select current_timestamp AT time zone 'PST';
timezone
----------------------------
2003-06-26 04:24:38
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
