11/22/2024 10:51:44 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Problem- saving incorrect time into database
Posted: 24 Aug 06 11:52 AM
|
fiogf49gjkf0d
Saving Incorrect time into database
Posted: 24 Aug 06 11:48 AM
We recently converted to 6.2 from 6.1 ( don't know if this is related to this issue). The problem I am having is as follows:
When writing a record into the database, the createdate and modifydate is 5 hours ahead of what it realy should be...
... I have traced the code to the point just before the call to the objRS.Update and the time looks fine (what it should be).
... I have also, duplicated the same functionality in Query Analyzer and found no problemthere...
Thanks in advance for your help!
|
|
|
|
Re: Problem- savint incorrect time into database
Posted: 24 Aug 06 12:08 PM
|
fiogf49gjkf0d Martin,
This is behaving correctly. In 6.2 dates are stored in UTC/GMT. If you use the SalesLogix OLEDB Provider to read the data it will auto adjust the datetime for you based on your timezone.
This is one of the reasons why it is critical to write data to the SalesLogix database via the SLXOLEDB Provider.
Timmus |
|
|
|
Re: Problem- savint incorrect time into database
Posted: 24 Aug 06 12:52 PM
|
fiogf49gjkf0d If you're seeing the dates incorrect via Query Analyzer, then this is expected and correct behavior. In 6.2 the dates are stored as UTC format in the database. The SLX OLEDB Provider translates the dates to the users local time zone (Windows setting). So in the client, all dates should look fine. But queries that do not use the SLX provider, such as via QA, the date translation will not occur and you will be seeing the UTC value.
So, make sure that:
1) You've run the UTC/GMT conversion utility when you upgraded
2) Any time you read from the SLX database you're using a connection via the SLX provider
3) Any time you write to the SLX database you're using a connection via the SLX provider
Then, all is well  |
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|