Kbase P162962: Is the client affected by changes in the system date or time where the database resides?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/6/2010 |
|
Status: Unverified
GOAL:
Is the client affected by changes in the system date or time where the database resides?
GOAL:
What happens to DATE functions on a client that is connected to the database server when the system date changes on the database server?
GOAL:
What happens to TIME functions on a client that is connected to the database server when the system time changes on the database server?
GOAL:
Do the client DATE functions remain the same until the database server is restarted after the system date changes on the database server?
GOAL:
Do the client TIME functions remain the same until the database server is restarted after the system time changes on the database server?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
OpenEdge 10.1x
OpenEdge 10.2x
OpenEdge Category: Database
FIX:
The database does most of its internal timekeeping in UTC. When using time-source set to some database, the client requests the current time from the database server and that database server sends its current time in UTC to the client. The client then converts the time in UTC sent by the database server to its local time on its side. In this case, clients are affected by time changes on the database server. When not using time-source, the client gets the current local time itself on whatever machine it is running on and not from any database server. In this case, time changes on the database server have no effect.