Issue
The dates shown in the ODBC database are in the incorrect format for the region set.
Environment
Sigma
ODBC
Date format
Windows 2008 Server
Cause
The engineer reports that although the correct date structure is shown in the Sigma logging, the format in the ODBC database is incorrect.
Resolution
This issue was reported on a Windows 2008 Server.
Although all of the obvious entries had been changed to the correct regional and language format, one had not.
Locate the entry in Regional settings "Copy all settings to all new users" which should be set to the required regional and language format.