ServiceNow REST API Call Timezone

[Shekar6]

I am trying to poll servicenow incident records every day to our local database for some analytics purpose. I am using REST API calls like this "https://*******.service-now.com/api/now/table/incident?sysparm_query=sys_updated_on>=javascript:gs.dateGenerate(%272018-03-01%27,%2700:00:00%27)^sys_updated_on<=javascript:gs.dateGenerate(%272018-03-01%27,%2723:59:59%27)".

The problem is the records which i am getting in the REST response is GMT but my customer wanted to the data in EST timezone. So it will be really helpful if i can set my rest api account to set the default timezone to EST to that i can get response in EST instead of GMT. 

Can someone help me whether it is possible to set the timezone for the api call account or i need to write a custom code in my sql database (destination) to convert GMT to EST.

Please help it is URGENT. Any help would really approciated

[Gaurav Bajaj]

Hi,

If you add another filter to your query to display dates with display value, you can get the dates in EST else it would keep giving in GMT.

Please mark it correct/helpful based on the response.

Thanks
Gaurav