Thanks Paul, I was hoping you were still hanging around here ;) Pls
forgive my ignorance in this area, I am truly clueless...but learning.

The datasource I'm running against has date/time stored in local time,
EST. On the "search parameter" page of a report I'm offering a drop down
similar to what windows uses in the clock of the OS. Essentially the
user picks the GMT/UTC offset they wish to use when running the report.
The datetime displayed on the resulting report is a conversion of the
original date/time to the GMT offset selected by the user.

Example:

1. Value in Database: (GMT -5:00 hours) Eastern Time (US & Canada)
01/01/2004 14:00

2. User Selects (GMT -8:00 hours) Pacific Time (US & Canada)

3. Difference is 3hrs

4. Value displayed: 01/01/2004 11:00

" however if you're only using UTC (not sure what you meant) then
there's 
no point worrying about DST."

>From your definition (I think) my approach is valid?

Cheers!
Stace 


-----Original Message-----
From: Paul Hastings [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 06, 2004 11:34 PM
To: CF-Talk
Subject: Re: Timezone and Daylight Savings

Stacy Young wrote:
> My question is someone asked about Daylight Savings and how that would
> affect people in other parts of the world. Is this something that one
> would need to account for? As far as I know it's hit and miss as to
who

no it's not "hit or miss". depends a great deal on history, economic 
ties & physical location. i'd advise using java's TZ data & let your 
users pick their TZ (and let the underlying java worry about if and when

they use DST, etc.):

http://www.sustainablegis.com/projects/tz/testTZCFC.cfm

however if you're only using UTC (not sure what you meant) then there's 
no point worrying about DST.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186490
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to