CRM date function fn_UTCToLocalTime is giving NULL RRS feed

  • Question

  • Hello,

    I have come across the CRM built in date function "dbo.fn_UTCToLocalTime()" which gives the local time.

    Actually when I login into the crm database server and ran the below query

    Select dbo.fn_UTCToLocalTime(GetUTCDate())

    it is giving the result as expected.

    But, when I access the database from my machine using sql authentication then the same query is giving NULL value.

    Can anyone suggest why this is happening?

    Your assistance will be highly appreciable. Thanks in advance.



    Wednesday, August 10, 2011 3:17 PM


All replies