390
Hello,
I have CRM online with Data Export Service. When I do sql queries I see that the hours are not correct, how can I format the hours to their correct time zone in SQLServer? Some dates have one hour less and another two hours less.
Thank you,
Best regards,
*This post is locked for comments
I believe you need to pull the UTC times from the CRM databases (Entity). CRM stores these in UTC format in database and then user pulls records, CRM business layer takes care of the conversion as per the selected timezone. Since you dont have CRM business layer in between now... you may have to do the conversion yourself.
Some more details here:
docs.microsoft.com/.../behavior-format-date-time-field
Hope this helps,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (