I have a COBOL application that we need to support on multiple time
zones.  I realize that you can set the TZ variable and use FUNCTION
CURRENT-DATE to get the local time.

The problem comes in where you have users in differing timezones and
posting to the same datasets.

Is there a way to convert a given date/time to a standard time zone and
back again using an intrinsic?

Example:  Set the TZ variable for the session to the local time zone.
When writing information to the database convert the local time to
GMT.  Then when retreiving the data from the database convert the
date/time to the local time again.



Sent via Deja.com http://www.deja.com/
Before you buy.