Question

How to change time zone used inside FlexiCapture 12?

Answer

The FlexiCapture 12 allows adjusting time zones on either the SQL Server or Azure side.

To change the timezone it is necessary to modify the ChangeTimeZone.sql script, located at C:\inetpub\wwwroot\FlexiCapture12\Server. This script is responsible for managing timezone settings within FlexiCapture. It includes a function named GetCustomDateTVF, which determines the current date and time based on a specified timezone.

To shift the timezone, please perform the following steps:

1. Navigate to C:\inetpub\wwwroot\FlexiCapture12\Server
2. Open the ChangeTimeZone.sql file using a suitable SQL editor.
3. Find the line containing the GetCustomDateTVF function. It will look similar to this:

   Select SYSDATETIMEOFFSET() at time zone 'Greenwich Standard Time' as CustomDate

4. Replace 'Greenwich Standard Time' with your desired timezone ID.
   The comprehensive list of supported timezone identifiers can be found by running the following query in SQL Server Management Studio (SSMS):

   Select * from sys.time_zone_info

   This query will display a list of all available timezone IDs within the SQL Server instance.
   
5. Choose the appropriate name that matches target timezone. For example, to set the timezone to Central European Standard Time, it is necessary to modify the line of code as follows:

   Select SYSDATETIMEOFFSET() at time zone 'Central European Standard Time' as CustomDate

6.  Ensure your FlexiCapture 12 database is selected in SSMS and click on the Execute button to run the modified script.