Database Administration (MOSC)

MOSC Banner

Handle Different Timezones

edited Sep 25, 2011 9:57PM in Database Administration (MOSC) 3 commentsAnswered

Hi all,
DB version: 10.2.0.5 , OS version: Oracle Solaris on SPARC (64-bit)

Problem:

How can we handle different time zones if we have a centralized database across few countries having different time.
in any transaction done we want to append local time of the user doing the transaction and the user will be an LDAP user e.g u1,u2,u3 etc connecting to database by a common data source user.

Below is the example.
- If task management is deployed in Kenya to serve 3 surrounding countries (Kenya which is GMT+3, Ghana GMT, and Nigeria GMT+1).
- If an agent in Nigeria created a task order at 5pm Nigeria time, we need to know whether the task will be created in the system using the local time of Nigeria (5 pm where the operation actually initiated), or it will be the time where the server exists (in this case Kenya where the time would say 7pm instead).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center