Skip to Content
author's profile photo Former Member
Former Member

SAP Time zone vs oracle time zone

Hello Experts,

I am confused by SAP's system time zone setting and oracle database's time zone setting.

Can I change SAP time zone setting without affecting the database time? Are they the same thing? Must I restart SAP / database / server after the TZ change at SAP-level to effect it? Is OS time zone = database time zone = SAP time zone?

Has this anything to do with database timestamp?

Pls advice.



(I promise to award full points for best answer).

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2005 at 12:42 PM

    Hello ernesta,

    As I know, SAP's time is a mathematic calculation on the server/database's time.

    This calculation is called time zone. Using transaction STZBC you can change your country's settings (for example CET+2 and etc). After the changing you'll have to restart the SAP instance.

    You can set time zone setting to specific users via transaction SU01.

    Furthermore, I suggest you to read several notes, maybe they could help you in the future:

    Note 184992 - Country/time zone assignment not correct

    Note 129266 - One hour time deviation

    Note 102088 - End of daylight saving time: the "double hour"

    Note 081950 - Time zones: local date in dialog and in RFC

    Best Regards,

    Dimitry Haritonov

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.