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