Re[2]: Daylight Savings and Logs

Text below "Reply Separator" not entirely true. If I'm running an ACE report that uses date paramters, such as TODAY, and I set and export my TZ variable to be UTC, i.e. TZ=UTC0UTC; export TZ, I get the UTC date for TODAY if this is run on the machine containing the database, i.e.: sacego -d mydbase myreport However...if I specify the server name: sacego -d mybase@myserver myreport I always get whatever default TZ is on the server instead of what I specified, since the UNIX TZ variable information apparently doesn't get passed to Informix STAR. This happens even if I run the second command on the machine containing the database. Information on timezone is conveniently ommitted from the bookshelf of Informix manuals we have. This leads to a question...how do people handle the entry of time-series data on a very large WAN? For instance, say you're keeping track of livestock transactions. Transactions in Tokyo get entered, with the computer in whatever time zone that is in. Same thing for New York, NY (EST/EDT), Los Angeles, CA (PST/PDT) and Goodland, KS (CST/CDT). Ideally, each transaction timestamp, when entered, would be converted to UTC. Each user should then be able to pull up a time series of transactions made by all offices in the company, relative to his/her time zone. A user in Union City, IN should be able to see everything in EST, while another user, 15 feet away in Union City, OH should be able to see everything in EDT, if desired. How is this done? ______________________________ Reply Separator _________________________________ Subject: Re: Daylight Savings and Logs Author: Dan Madvig <daniel@genesis.admin.bethel.edu> at smtpgate Date: 3/28/96 10:21 PM At 09:29 PM 3/27/96 GMT, John Callaway wrote: >You didn't mention what operating system you are using. If you are using >UNIX, I suggest that you check out that different time zone parameters. We >use EST5EDT, which automatically translates the UNIX time (which is kept in >coordinated universal time) to the local time zone. See the manpages on >'tztab' for more information. > >Therefore, the time never gets changed on the UNIX platform, only the >translation. 'Smart' UNIX programs know this and bypass the time zone for >time stamps. So is OnLine 5 among the 'smart' programs? Based on other features, I'd guess yes. Dan Madvig e-mail: d-madvig@bethel.edu Bethel College & Seminary phone: (612) 638-6414 3900 Bethel Drive fax: (612) 638-6001 St. Paul, MN 55112 "Write a wise saying and your name will live forever" -- Anonymous