To configure the SQL server to support EU date formatting, complete the following steps.
Note: When upgrading from previous PACSgear
Enterprise (previously known as PACSgear Core Server) versions,
the SQL column ‘’ is added and the value defaults to ‘null’. The
server interprets a ‘null’ value the same as a ‘0’ (FALSE) value.
- Open Microsoft SQL Management Studio.
- In the Databases tree, navigate to PGCore > Tables > dbo.ServerDefaultsTbl.
- Double-click the UseUTC column.
- Change the value of this column to 1 or true.
- Double-click the DateFormat column.
- Change the value of this column to the appropriate region code.
- Save your changes.
- Restart the SQL and PGEnterprise services.