How to use fn_UTCToTzCodeSpecificLocalTime

(0) Share

Report

Posted on by damka

120

I need to get my records after checking Utc time zone ,I have a gap of 2 hours between my CRM and DB. I am trying to use fn_UTCToTzCodeSpecificLocalTime but my query takes long time and I'm not sure that I'm using it right.
The need is
1- to use the date according to CRM and not DB .
2 - I need to make sure this date is before june 2022.
What am I missing ?
This is my query:

select distinct top 5 accountnumber,bci.CreatedOn

from AccountBase ac
join bcis bci on ac.AccountId = bci.PayingAccountId

where

 convert(varchar, dbo.fn_UTCToTzCodeSpecificLocalTime(bci.CreatedOn,135)) < '2022-06-01'