[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Converting to Local Date-Time Zones on VAX/OpenVMS
- Subject: Converting to Local Date-Time Zones on VAX/OpenVMS
- From: Toni Iacobo 617-441-2364 <TONI@epub.med.iacnet.com>
- Date: Thu, 30 Jan 1997 13:58:05 -0500
Hello,
I am writing Customer Usage reports for customers in the US, UK, Canada,
and Australia. (This list could be expanded in the future.)
Our accounting files record event data in the time of the US Eastern
time zone. I would like to convert this time into the local time of the
customer.
We are using SQR on VMS and Sybase. Does anyone know of any resources
or have suggestions for handling this?
I've seen a set of "time zone" functions on HP-UNIX. They have all the
time rules and zone definitions and a "zone" compiler. By setting the
appropriate TZ environment variable, you can use
the standard C time functions (gmtime, localtime, asctime, etc.) to convert
the time. My plan is to try and write a UFUNC function using VAX system
routines and logicals to do the same once I find VAX documentation on their
time zone rules format and time system services.
Does anyone have other suggestions or comments or have tackled this problem
before with SQR on the VAX? or know of where this can be found?
Thanks in advance for any help,
Toni
Toni Iacobo
Information Access Co.
toni_iacobo@iacnet.com