Date mismatch between MSCRM and SQL Server Database

Question

when i am inserting any datetime field in MSCRM it is showing fine in MSCRM. But in Database it is showing 5hours 30 minutes backward. in MSCRM the time format is "English UK" and Timezone setting is GMT +5.30.

Please suggest.

Thanks and Regards
Kumar

---

kumar

Answer 1

Hi kumar,

that is right. The CRM saves the date and time in UTC-format in the database.

To use the date and time in your application, you should use the filtered views, the display the date and time in the timezone of the user.

To get the time and date in your SQK-query, you can use the following:

Select DateAdd(hour, DateDiff(hour, GetUtcDate(), GetDate()), <field>)

---

Viele Grüße

Michael Sulz
axcentro GmbH
MVP für Microsoft Dynamics CRM

Answer 2

 Hi Michael,

                  Thanks for your solution, i have one question here if i want to send the confirmation message by waiting  one hour, i am fetching this time from crm db directly because i am sending message from another application , if i want to check correct one hour lag,what can i do to achieving with out effecting the functionality

Thanks in advance...........

Regards,

Kumar

---

kumar

Answer 3

Hi,

you can post your english crm questions here: http://social.msdn.microsoft.com/Forums/en-US/crm/threads

Best regards,
Jürgen

---

Jürgen Beck

Dipl. Kfm./Wirtschaftsinformatik
MVP, MCSD.NET, MCITP DBA, MCDBA, MCSE
Microsoft Certified Business Management Solutions Professional
Microsoft Certified CRM Developer
Microsoft Certified Trainer

ComBeck IT Services & Business Solutions
Microsoft Gold Certified Partner
Microsoft Small Business Specialist

Developing & Supporting Business Applications from small business to big enterprises covering scores of sectors

http://www.combeck.de