> Our server is based in CST and our client is EST. > All the inserts that I have written use the sysdate for a > field called > createdDate. (which is obviously servertime CST)
> What is the best way to handle the timezone issues > throughout the site? > Derek Depends on the site and how it will be used. If you intend to be able to provide time information relative to the viewer and the viewer may be in multiple timezones, then you've got a lot of management to consider. If you only have to account for one time zone, you can just put "EST" or "CST" anywhere you display a time value and let people do their own calculations. Even if users are in multiple time zones, this is still a viable solution imho, by using the server time-zone as a reference. If you wanted to standardize multiple systems so that all their times are synched, you'd use something like GetUTCDate() to determine the "Universal Time Coordinate" time, which is the international standard. Not sure if UTC functions in SQL Server or Oracle account for things like small islands where daylight savings time occurs during strange parts of the year, though I suspect they account for DST in most of the major localles like north and south america, australia, and the better part of the eurasian continent. By and large I find programming things for time and time-zones rather frustrating. There are a couple of commercially available databases that give pretty thorough information regarding global time zones and DST's. A Google search should produce one or two if it becomes important for you. hth s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
