<html><DIV>
<P>does your method take in the consideration for daylight savings time? also this
relies on user setting his/her computer time correctly. well it all comes down to how
important this is in your application. for us, we were thinking about doing the same,
but the ability to determine time in timezone between users was crucial part of the
app and we didn't want to make any part of the site relying on javascript. so we
couldn't go this route.<BR>just trying to help.<BR></P></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Marc Funaro" <[EMAIL PROTECTED]>
<DIV></DIV>>Reply-To: [EMAIL PROTECTED]
<DIV></DIV>>To: Fusebox <[EMAIL PROTECTED]>
<DIV></DIV>>Subject: RE: [OT] Timezone madness
<DIV></DIV>>Date: Fri, 30 Mar 2001 11:07:50 -0500
<DIV></DIV>>
<DIV></DIV>>I don't see how this can help if your dll requires a timezone -- which
is
<DIV></DIV>>exactly what I am attempting to determine. I am not translating from
one
<DIV></DIV>>timezone to many different timezones.
<DIV></DIV>>
<DIV></DIV>>One last time, in a different set of words:
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>We have ONE constant: The server's local time. We know what time zone
the
<DIV></DIV>>server is in. We convert that time zone to UTC using the DateConvert()
<DIV></DIV>>function. Therefore, we know what time it is, in UTC, when the user
submits
<DIV></DIV>>their form.
<DIV></DIV>>
<DIV></DIV>>Along with the form submission, we "secretly" send the time and date on
the
<DIV></DIV>>USERS computer, in a hidden field, using javascript.
<DIV></DIV>>
<DIV></DIV>>We convert that hidden field data to ODBC Date time format.
<DIV></DIV>>
<DIV></DIV>>We compare that data with the known UTC, to determine the USER'S
timezone
<DIV></DIV>>offset, which we then store in the database.
<DIV></DIV>>
<DIV></DIV>>We store ALL dates and times for all records in UTC format, and we use
the
<DIV></DIV>>USER'S timezone offset to display times and dates to them according to
their
<DIV></DIV>>timezone.
<DIV></DIV>>
<DIV></DIV>>The code that does not work as it should, unless you make UTC at least
one
<DIV></DIV>>second faster than it is:
<DIV></DIV>>
<DIV></DIV>><CFOUTPUT>
<DIV></DIV>> <CFSET 12:00:00?) TestUTCNow='CreateODBCDateTime("3/30/2001'>
<DIV></DIV>> <CFSET 4:00:00?) TestUserTime='CreateODBCDateTime("3/30/2001'>
<DIV></DIV>> <CFSET TestUserTime) TestUTCNow, UserTZOffset='DateDiff("h",'>
<DIV></DIV>> User's TimeZoneOffset = #UserTZOffset# <!--- This SHOULD be -8, but is
</DIV>>only -7! Unless, you make UTCNow equal to "3/30/2001 12:00:01" --->
<DIV></DIV>></CFOUTPUT>
<DIV></DIV>>
<DIV></DIV>>The output of the above hard-coded sample SHOULD be "-8", meaning the
user
<DIV></DIV>>is in California, 8 hours BEHIND UTC. When displaying dates and times
out
<DIV></DIV>>of the database for this user, we will first subtract 8 hours from the
data.
<DIV></DIV>>
<DIV></DIV>>However, the above code only spits out -7. This is the problem at hand.
<DIV></DIV>>
<DIV></DIV>>Nobody yet has established a better way to automatically determine the
<DIV></DIV>>user's time zone other than what I have set forth above. Our way WOULD
<DIV></DIV>>work, if the calculation block of code, as I provided above, would do
what
<DIV></DIV>>it is supposed to. Is this not a bug in CF 4.5?
<DIV></DIV>>
<DIV></DIV>>Additional, just discovered information -- if we LEAVE OFF the
"seconds"
<DIV></DIV>>part of the user's time/date information as submitted in the hidden
form
<DIV></DIV>>field, the above code DOES spit out -8. Try it:
<DIV></DIV>>
<DIV></DIV>><CFOUTPUT>
<DIV></DIV>> <CFSET 12:00:00?) TestUTCNow='CreateODBCDateTime("3/30/2001'>
<DIV></DIV>> <CFSET TestUserTime='CreateODBCDateTime("3/30/2001' 4:00:?)>
<DIV></DIV>> <CFSET TestUserTime) TestUTCNow, UserTZOffset='DateDiff("h",'>
<DIV></DIV>> User's TimeZoneOffset = #UserTZOffset#
<DIV></DIV>></CFOUTPUT>
<DIV></DIV>>
<DIV></DIV>>With the SECONDS missing, it calculates the correct datediff.
<DIV></DIV>>
<DIV></DIV>>What gives?
<DIV></DIV>>
<DIV></DIV>>I appreciate the responses to date -- thank you!
<DIV></DIV>>
<DIV></DIV>>Marc
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>From: wish wish [mailto:[EMAIL PROTECTED]]
<DIV></DIV>>Sent: Friday, March 30, 2001 10:42 AM
<DIV></DIV>>To: Fusebox
<DIV></DIV>>Subject: Re: [OT] Timezone madness
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<P>i have a .dll which takes in a timezone and a time, it translates it to
<DIV></DIV>>the time in the timezone you sepecified. all you need to do is to make
it a
<DIV></DIV>>CFX custom tag(i didn't have time to do it).
<P></P>
<DIV></DIV>>
<P>if you want i can give it to you. my only request is to share it once you
<DIV></DIV>>get to work as a CFX tag. you also can test a little more. email me
<DIV></DIV>>offlist.
<P></P>
<DIV></DIV>>
<P>thanks</P>
<DIV></DIV>>
<P>alex<BR><BR></P>
<DIV></DIV>
<DIV></DIV>>
<DIV></DIV>
<DIV></DIV>>
<DIV></DIV>>From: "Marc Funaro" <[EMAIL PROTECTED]>
<DIV></DIV>>
<DIV></DIV>>Reply-To: [EMAIL PROTECTED]
<DIV></DIV>>
<DIV></DIV>>To: Fusebox <[EMAIL PROTECTED]>
<DIV></DIV>>
<DIV></DIV>>Subject: [OT] Timezone madness
<DIV></DIV>>
<DIV></DIV>>Date: Fri, 30 Mar 2001 07:56:57 -0500
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Greetings all,
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Been fighting with this, can't figure out the answer, and
<DIV></DIV>>going mad. I am
<DIV></DIV>>
<DIV></DIV>>storing all times and dates in a database in UTC (GMT)
<DIV></DIV>>format, to properly
<DIV></DIV>>
<DIV></DIV>>show users the time according to their time zone, and allow
<DIV></DIV>>the server to be
<DIV></DIV>>
<DIV></DIV>>(re)located anywhere in the world without having to change
<DIV></DIV>>code or data.
<DIV></DIV>>
<DIV></DIV>>Ignore Daylight Savings Time considerations for this example
<DIV></DIV>>(though if you
<DIV></DIV>>
<DIV></DIV>>have any suggestions, I am all ears!) -- I have not had the
<DIV></DIV>>chance to even
<DIV></DIV>>
<DIV></DIV>>think about DST yet.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>1. The user fills out a form. When they submit, a hidden form
<DIV></DIV>>field is
<DIV></DIV>>
<DIV></DIV>>populated with the user's current system time and date, using
<DIV></DIV>>javascript.
<DIV></DIV>>
<DIV></DIV>>Since Javascript calculates the months from 0 to 11, I add
<DIV></DIV>>ONE to the month
<DIV></DIV>>
<DIV></DIV>>at the time I create the timestamp.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>2. The form submits to a page which converts the current CF
<DIV></DIV>>Server time to
<DIV></DIV>>
<DIV></DIV>>an ODBCDateTime in UTC. The User's hidden time field is also
<DIV></DIV>>converted to
<DIV></DIV>>
<DIV></DIV>>an ODBCDateTime format.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>3. The different between the user's timestamp on their
<DIV></DIV>>machine, and the UTC
<DIV></DIV>>
<DIV></DIV>>according to the server creates the Time Zone Offset for that
<DIV></DIV>>user -- their
<DIV></DIV>>
<DIV></DIV>>actual TIME ZONE.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>As a real-world example:
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>-- Assume that the Server and the User both use a utility
<DIV></DIV>>which maintains
<DIV></DIV>>
<DIV></DIV>>synchronization with time servers on the Internet; therefore
<DIV></DIV>>the two systems
<DIV></DIV>>
<DIV></DIV>>are within milliseconds of Atomic Time.
<DIV></DIV>>
<DIV></DIV>>-- On March 30th, 2001, a user in NY submits a form at 7am
<DIV></DIV>>EST, on a server
<DIV></DIV>>
<DIV></DIV>>in California (4am PST).
<DIV></DIV>>
<DIV></DIV>>-- The software calculates the current UTC time as being
<DIV></DIV>>12:00:00PM (4am CA
<DIV></DIV>>
<DIV></DIV>>time is 12 noon GMT/UTC).
<DIV></DIV>>
<DIV></DIV>>-- The difference between the user's time (3/30/2001
<DIV></DIV>>4:00:00am) and UTC
<DIV></DIV>>
<DIV></DIV>>(12:00:00PM) is -8 hours, which is absolutely correct; we
<DIV></DIV>>know the user is
<DIV></DIV>>
<DIV></DIV>>in PST because of this difference.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>NOW!: The code snippet below shows the CF Code that calcuates
<DIV></DIV>>the
<DIV></DIV>>
<DIV></DIV>>difference between the user's time and UTC. However, if you
<DIV></DIV>>run this code,
<DIV></DIV>>
<DIV></DIV>>you will NOT get a difference of - 8 hours, but instead, -7
<DIV></DIV>>hours. If you
<DIV></DIV>>
<DIV></DIV>>increment UTC by at least one second, it then calculates the
<DIV></DIV>>timezone
<DIV></DIV>>
<DIV></DIV>>properly; but one cannot assume that the user and the server
<DIV></DIV>>will always be
<DIV></DIV>>
<DIV></DIV>>out of synch... although it is most likely a certainty, I do
<DIV></DIV>>not wish to
<DIV></DIV>>
<DIV></DIV>>assume anything.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>I also do not wish to make the user choose their time zone on
<DIV></DIV>>the form; I
<DIV></DIV>>
<DIV></DIV>>really wanted this to be automatic.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Here is the code:
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>><CFOUTPUT>
<DIV></DIV>>
<DIV></DIV>> <CFSET 12:00:00?) DIV
<>>TestUTCNow='CreateODBCDateTime("3/30/2001'>
<DIV></DIV>>
<DIV></DIV>> <CFSET 4:00:00?) DIV
<>>TestUserTime='CreateODBCDateTime("3/30/2001'>
<DIV></DIV>>
<DIV></DIV>> <CFSET TestUserTime) TestUTCNow, DIV
<>>UserTZOffset='DateDiff("h",'>
<DIV></DIV>>
<DIV></DIV>> User's TimeZoneOffset = #UserTZOffset# <!--- This SHOULD
</DIV>>be -8, but is
</DIV>></DIV>>only -7! Unless, you make UTCNow equal to "3/30/2001 12:00:01" --->
<DIV></DIV>>
<DIV></DIV>></CFOUTPUT>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Has anyone solved this problem, or have a different way of
<DIV></DIV>>putting the
<DIV></DIV>>
<DIV></DIV>>user's timezone into the database, including DST issues?
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Thanks in advance,
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
<DIV></DIV>>.. . .
<DIV></DIV>>
<DIV></DIV>>Marc Funaro, President
<DIV></DIV>>
<DIV></DIV>>Advantex Technical Consulting Services
<DIV></DIV>>
<DIV></DIV>>5547 State Highway 12
<DIV></DIV>>
<DIV></DIV>>Norwich, NY 13815
<DIV></DIV>>
<DIV></DIV>>Phone: 607-336-6895
<DIV></DIV>>
<DIV></DIV>>Fax: 801-383-4864
<DIV></DIV>>
<DIV></DIV>>Internet: http://www.advantex.net
<DIV></DIV>>
<DIV></DIV>>Email: [EMAIL PROTECTED] >/><?xml:namespace prefix = mailto
/><mailto:[EMAIL PROTECTED]>
<DIV></DIV>>
<DIV></DIV>>.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
<DIV></DIV>>.. . .
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
