Our implementation is on Amazon Web Services (AWS) cloud. We are using SQL Server (MS SQL) as the database which is also Amazon AWS Relational Database Services (RDS).
The SI server is on RHEL 7 and the server time zone is set at EST as the business happens in the zone. The Database server time zone is in UTC as that is the default timezone for all Managed Services of Amazon. For SQL Server alone there is no option to change the time zone.
We need all our process to reflect EST. But the Sterling File Gateway alone is using Database time and the corresponding BPs are using the server time.
Need a change so the SFG system should also use SI server instead of the database time.