Re: Time Zones + GMT
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42386
interpreted = N
texte = Clint Davis wrote: > Since my server is located in the US Central Time Zone, I'm storing a time > zone preference in my database as the offset of Central Time (+1 for > Eastern, +0 for Central, -1 for Mountain, -2 Pacific). I need to use this > offset to calculate the correct date and time for the time zone specified by > the client in the database.Why don't you store the offsets as relative to GMT, because then you will always have a positive offset?> > I think I'm going to need to convert to GMT and back or something like that, > but I'm not sure. I want to display the results of the math as: > Weekday, Month DD, YYYY | HH:MM:am/pm. > [math time]localtime={[date %X]}+{[youroffset]:00:00}-{[offset]:00:00}[/math]Note that this will not work around midnight for anyone west of you, since you will be reporting the wrong date. Look in the archives for my MIMEHeaders.inc include file which has some convoluted logic to get this right...It would be very nice is WebDNA was extended to include GMT math, though this relies on the underlying gmtime() implementation of the O/S...John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Clint Davis wrote: > Since my server is located in the US Central Time Zone, I'm storing a time > zone preference in my database as the offset of Central Time (+1 for > Eastern, +0 for Central, -1 for Mountain, -2 Pacific). I need to use this > offset to calculate the correct date and time for the time zone specified by > the client in the database.Why don't you store the offsets as relative to GMT, because then you will always have a positive offset?> > I think I'm going to need to convert to GMT and back or something like that, > but I'm not sure. I want to display the results of the math as: > Weekday, Month DD, YYYY | HH:MM:am/pm. > [math time]localtime={[date %X]}+{[youroffset]:00:00}-{[offset]:00:00}[/math]Note that this will not work around midnight for anyone west of you, since you will be reporting the wrong date. Look in the archives for my MIMEHeaders.inc include file which has some convoluted logic to get this right...It would be very nice is WebDNA was extended to include GMT math, though this relies on the underlying gmtime() implementation of the O/S...John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
John Peacock
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
about this server and links to who (1997)
Running 2 two WebCatalog.acgi's (1996)
Need relative path explanation (1997)
Cart questions (1997)
3.0 [TEXT] variables (1998)
WC2b15 File Corruption (1997)
Internet Explorer 6 Form problems (2005)
HTML encoding in URLs (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
all records returned. (1997)
WC Database Format (1997)
Frames and WebCat (1997)
Help formatting search results w/ table (1997)
Slowness (2004)
Custom WebCat Prefs ... (1997)
CVS Files for databases (2000)
indexing dates (1998)
Nested search (1997)
emailer (1997)
[search] & [encrypt]/[decrypt] (2001)