Hi John,
Did you solve this?
Paul.
On 27/03/2009, at 9:52 PM, John Barrett wrote:
>
> 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:4475
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
