Skip to Content
author's profile photo
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.

Regards,

Ernesta

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    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 comment
    10|10000 characters needed characters exceeded