When timestamp is written into the database u...

(Yossi Oulu) #1

When timestamp is written into the database using ‘Change Timestamp’ it is using the GMT timezone. When I use the now() it is using my timezone (GMT+2). Is there a way to set it that it will all use my timezone?

The Dashboard is also using the GMT and not my timezone.

A bit confusing. Any idea?

(Levent KULAÇOĞLU) #2

@Yossi_Oulu

Ensure that your gSheet timezone and app tables’ locale are correctly set. The servers or systems always return UTC date-time and it’s converted to local date-time either by your browser or by your app’s locale setting.

(Yossi Oulu) #3

@Levent_KULACOGLU not using google sheet. Using mssql database

(Dinh Nguyen Nguyen) #4

@Yossi_Oulu Is your device timezone GMT+2?

(Yossi Oulu) #5

@Harry yes.