SAP Time zone vs oracle time zone

[Former Member]

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).

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Thanks Dimitry!

In my situation, I need to change the SAP System Time Zone via STZAC as its wrongly set.

Can I do so without restarting the database?

Thanks.

Regards,

Ernesta

[Former Member · Accepted solution]

Dear Ernesta,

If the seetings in STZAC in only for SAP instance time zone so you should restart only the SAP instance.

If you need to change the dsatabase time so you need to restart the SAP instance and the Database instance.

Regards,

Dimitry Haritonov

[Former Member · Accepted solution]

Thanks Dimitry! Full Points!