Time zone for SAP hana standby

[Former Member]

Our company IT data center is at east coast and our DR center is at central time zone(CET).

Our SAP Hana is at east coast and now we plan to set up standby at CET. It's more than 100KM but we use async mode so this is not a problem.

Our concern is that if both primary and standby can use the same time zone , e.g. EST or UTC.

Thanks!

[Former Member · Accepted solution]

Hey.. depending on location you should keep it the same either one of them else might have huge issues....but I would rather inform about the timezone settings and issues that we faced recently.. Please make sure your User TZ and Hardware TZ are same else during DST switch might create huge issues and moreover please maintain the TTZ* tables as per note 1791342 & 1932132 but

[Former Member]

Dear

Yes - please see SAP HANA Database - SQL Script Guide

https://service.sap.com/~sapidb/011000358700000604932011

page 27 - chapter Relational Operators - operator CE_CALC

Date Functions

utctolocal

interpret datearg (a date, without timezone) as utc and convert it to the timezone named by timezonearg (a string)

iutctolocal(datearg, timezonearg)

localtoutc

convert the local datetime datearg to the timezone specified by the string timezonearg, return as a date

localtoutc(datearg, timezonearg)

Regards