Commodore
Commodore
829 views

How to deal with Daylight Save time ?

Jump to solution

Hi all, 

We are working with BSM 9.26 distributed (GW and DP) installation. There are another team using an ETL to extract the info from our database and load it in another dashboard. We are getting problems because the sampletime and dbdate fields doesn't match, sampletime is in GMT and dbdate in GMT+1 (BST).

We'd like to know if there is any way to set the timezone to London time zone and deal with the daily save time, I mean, when the time change, it is changed in the sampletime field also.

We realized that there is an option to set the time zone in the admin/platform/infractucture setting, but we dont know the format to introduce the time zone and if it is going to deal with the DST

Thanks and regards 

Labels (1)
Tags (2)
0 Likes
1 Solution

Accepted Solutions
Micro Focus Expert
Micro Focus Expert
You cannot change the timezone of "sample_time" so you cannot force BSM to align DBTime and sample_time.
I already recommended you what is the correct path to solve your issue. There isn't anything else I can think of.

Asaf

View solution in original post

3 Replies
Micro Focus Expert
Micro Focus Expert

first of all, i think you wanted to ask about "Daylight Saving Time".

moreover, the data is stored in the DB according to the DB timezone, which must be the same as BSM servers timezone. when querying the DB for different reports we use the "sample_time" field and timezone is converted according to the user's timezone as defined in Personal Settings.

instead of querying directly the DB you can use the Custom Query Builder which queries the DB using the timezone of the logged-in user. you can then export the report to URL and consume it in your dashboard tool. this way you are taking care of DST since BSM will take care of it for you.

Commodore
Commodore

Hi Asaf,

Sorry, yes, I mean Daylight Saving Time.

The Database is in the proper timezone (BST) and therefore DBdate field is in this timezone, however , the other field, sampletime is not, and AFAIK, this is inserted in GMT. Am I right?

Are there any way to align these two fields? 

It easier way use the query against the database in order to be able to fill the other team dashboard, and because of that we are using this procedure.

Do you think this is something that we can deal ? What about the timezone setting in admin/platform/Infractucture setting ?

 

Regards

 

Micro Focus Expert
Micro Focus Expert
You cannot change the timezone of "sample_time" so you cannot force BSM to align DBTime and sample_time.
I already recommended you what is the correct path to solve your issue. There isn't anything else I can think of.

Asaf

View solution in original post

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.