Kbase P85903: Is there a way to change the value of TIME / TODAY to accommodate time zones?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/19/2010 |
|
Status: Verified
GOAL:
Is there a way to change the value of TIME / TODAY to accommodate time zones?
GOAL:
How can a client located in one time zone use the time zone of a database server located in a different time zone?
GOAL:
How to use the TIME-SOURCE session attribute
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The TIME-SOURCE attribute of the SESSION handle allows time-related 4GL/ABL functions to get the time from a server in a different time zone.
TIME-SOURCE accepts either of the following settings:
"local" or the null string (""): Your application uses the client machine as its time source. The default value is "local".
"dbname": Your application uses the machine running the server for the database with the name dbname as its time source.
All time-related language elements, such as the MTIME, NOW, TIME, TIMEZONE, and TODAY functions, use the specified time source. This attribute is useful for client/server applications that span time zones.OpenEdge 10 also has a data type called "DATETIME-TZ" and a set of supporting functions to handle time zones in a variety of ways.