Hi,
I have a confusing question here. I use a server in Delware, but live in
Hawaii. I would like to "trick" the server so that it uses Hawaii Time instead
of East Cost time. I would like to come up with a solution so I don't have to
change all my cfqueries too.
I am not sure if I can use DateFormat or TimeFormat to achieve this. For
example, I have a tip that changes everyday at midnight(east coast) and would
like this to change to midnight here in Hawaii. if I know:
<cfset servertime = Now()>
<cfset time = Now()>
<cfset time = dateadd("h",-6,time) />
<cfoutput>The server's time, which is in Delaware is
#TimeFormat(servertime,'h:mm tt')#</cfoutput><br />
<cfoutput>The time in Hawaii is #TimeFormat(time,'h:mm tt')#</cfoutput>
this gives me the time difference between hawaii and east coast time (hawaii is
6 hours behind). If I can't trick the server how can I change the cfquery to
not display the tip until midnight for hawaii time? If I need to I can change
all the timeFormat on the site to reflect this, but would rather do it for the
server, but since it is a shared server, I don't have access to the cf admin.
Is there a way to use timezone with dateadd?
Thanks so much,
John
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4474
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
