# Source Time zone

**URL:** <https://developer.sailpoint.com/discuss/t/source-time-zone/12099>\
**Category:** SHF Discussion and Questions\
**Tags:** jdbc-connector, sailpoint-identity-security, sources\
**Created:** [June 8, 2023, 1:34pm UTC](https://developer.sailpoint.com/discuss/t/source-time-zone/12099 "2023-06-08T13:34:34Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manju22](https://avatars.discourse-cdn.com/v4/letter/m/45deac/32.png) [@Manju22](https://developer.sailpoint.com/discuss/u/Manju22)\
**Post date:** [June 8, 2023, 1:34pm UTC](https://developer.sailpoint.com/discuss/t/source-time-zone/12099/1 "2023-06-08T13:34:34Z")

</div>

We have a JDBC source with an account aggregation query with the filter “CURRENT\_TIMESTAMP”.

What is the timestamp it will take? Is that based on the VA time zone or the tenant time zone?

SELECT \* FROM table WHERE SHUTOFF\_DATETIME \<= CURRENT\_TIMESTAMP

---

<div class="post-metadata">

**Author:** ![ethompson](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/ethompson/32/17298_2.png) [@ethompson](https://developer.sailpoint.com/discuss/u/ethompson)\
**Post date:** [June 8, 2023, 1:38pm UTC](https://developer.sailpoint.com/discuss/t/source-time-zone/12099/2 "2023-06-08T13:38:33Z")

</div>

It should be based on the VA cluster time zone.

> **[Time Zones in IdentityNow - SailPoint Identity Services](https://documentation.sailpoint.com/saas/help/common/time-zones.html)**
>
> SailPoint Identity Services Documentation

---

<div class="post-metadata">

**Author:** ![Manju22](https://avatars.discourse-cdn.com/v4/letter/m/45deac/32.png) [@Manju22](https://developer.sailpoint.com/discuss/u/Manju22)\
**Post date:** [June 8, 2023, 1:44pm UTC](https://developer.sailpoint.com/discuss/t/source-time-zone/12099/3 "2023-06-08T13:44:10Z")

</div>

Thanks for the quick response. How can I check our VA cluster time zone?

I have four VAs in our VA cluster. 2 are located at Central Time, and 2 are located at Eastern Time.

---

<div class="post-metadata">

**Author:** ![ethompson](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/ethompson/32/17298_2.png) [@ethompson](https://developer.sailpoint.com/discuss/u/ethompson)\
**Post date:** [June 8, 2023, 1:58pm UTC](https://developer.sailpoint.com/discuss/t/source-time-zone/12099/4 "2023-06-08T13:58:23Z")

</div>

> **[get-managed-clusters | SailPoint Developer Community](https://developer.sailpoint.com/idn/api/beta/get-managed-clusters)**
>
> Retrieve all Managed Clusters.

There is a gmtOffset which will tell you the time zone.

![image](https://global.discourse-cdn.com/sailpoint/original/2X/d/ddbc92c9acf0f6c11dc2d0a0b003bd1a6dd4cd0a.png)

---

<div class="post-metadata">

**Author:** ![Manju22](https://avatars.discourse-cdn.com/v4/letter/m/45deac/32.png) [@Manju22](https://developer.sailpoint.com/discuss/u/Manju22)\
**Post date:** [June 8, 2023, 2:42pm UTC](https://developer.sailpoint.com/discuss/t/source-time-zone/12099/5 "2023-06-08T14:42:34Z")

</div>

Does the configuration change based on daylight savings?

---

<div class="post-metadata">

**Author:** ![ethompson](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/ethompson/32/17298_2.png) [@ethompson](https://developer.sailpoint.com/discuss/u/ethompson)\
**Post date:** [June 8, 2023, 2:57pm UTC](https://developer.sailpoint.com/discuss/t/source-time-zone/12099/6 "2023-06-08T14:57:59Z")

</div>

![image](https://global.discourse-cdn.com/sailpoint/original/2X/4/4e0b7dc708fd0327d40e1ba389b9f6e419b4c5e9.png)  
From the above link.

Since this is just gmtOffset, I would assume it would maintain and that daylight savings would not be a factor, but I have not see if it changes or not.

---

<div class="post-metadata">

**Author:** ![tyler\_stevens](https://avatars.discourse-cdn.com/v4/letter/t/8baadc/32.png) [@tyler\_stevens](https://developer.sailpoint.com/discuss/u/tyler_stevens)\
**Post date:** [June 8, 2023, 3:55pm UTC](https://developer.sailpoint.com/discuss/t/source-time-zone/12099/7 "2023-06-08T15:55:09Z")

</div>

There is a current bug related to the source timezones where the setting is not shown in the UI to update. Source timezones are set based on the cluster timezone, which was inadvertently removed during the change from the old VA UI to the new VA UI.

Here is a workaround to get the current setting, and update the setting:

Run GET /cc/api/cluster/list to get the cluster ID, and view the current gmtOffset.

Then, use this API call to update it:

POST /cc/api/cluster/update

```json
{
    "id":"clusterIdfromGETcall",
    "gmtOffset": "-6",
    "debug": false
}

```

This is a gmtOffset, so it does not update with daylight savings time. Currently, -5 is Central Time and -6 is Mountain Time during daylight savings.

This feature should return to the product UI in the very near future, but this should help to get you moving now.

Please let me know if you have any questions.

Thank you!  
Tyler

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [August 7, 2023, 3:55pm UTC](https://developer.sailpoint.com/discuss/t/source-time-zone/12099/8 "2023-08-07T15:55:16Z")

</div>

Closed on August 7, 2023, 3:55pm UTC

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.