StartTime of the Bot in SQL is Different from that of the time in Orchestrator

Help Orchestrator
,
1

Hello,
When I execute query in sql, the startTime of a Bot is displaying in GMT time zone than that of the Orchestrator time( EST TimeZone)
1.I tried by checking the Orchestrator settings and it is synced in EST
2. I tried by the Query, ( StartTime AT Time Zone ‘Eastern Standard Time’, but it is displaying result with same GMT Time -4 . But I want the Exact EST time in the StartTime column,

Is it something you can help with?

2

Hi @Nishanthi_Sankar,

Have you tried changing timezone in orchestrator from the screen shown below:

image
image1547×618 40.9 KB

Alternatively, you might want to consider updating timezone settings of your system/laptop.

Bringing both your system and orchestrator time zone in synch should do the trick.

Regards
Sonali

3

Hi Sonali, Yes first thing I checked is the orchestrator settings, it’s in EST time zone
Also my system time zone is in EST.
Only the db is displaying in GMT.

4

Hi @Nishanthi_Sankar,

Looks like db server is in GMT timezone settings.

And do you mean that start time of bot being displayed in GMT is in db column and you want to change the timezone of start time in db column?

Regards
Sonali

5

Yes Sonali,right.
But since orchestrator and db should be synced, I thought if there is any change in Settings that I have to do.
If I have to convert that from the Db side, I will take care of it :slight_smile:

6

Hi @Nishanthi_Sankar,

Looks like so… You might need to change timezone from db end so they are all in same timezone :slight_smile:

Regards
Sonali

7

Got it, Thank you!

8

Hi @Nishanthi_Sankar,

If your doubts are cleared and there are no further queries, I would suggest to mark solution so this topic can be closed :slight_smile:

Regards
Sonali

9

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