We are currently working on SLX v 6.2.5, when we stored data in a table, it appears SalesLogix oledb provider stored it in GMT format. Is there any way to store data in local time format?
SQL Server does the storing. It’s in datetime,not GMT, format. The VALUE is GMT. The provider converts it back to local time.
As long as you access the Data via the SLX OLEDB Provider, it will be returned on your Local Time Zone.
Otherwise, you just need to be aware of the Time difference and convert the values as necessary.