Thanks for your reply.

I have already tried all these ways, but the result is more varying in these cases.

Adding 5:30 is giving me a difference of only 30 mins approximately.

I used the below statement:

e.g.,

SELECT dateadd(hh,5.30,CAST(635302120392663258/864000000000.0 - 693595.0 AS DATETIME))

It's giving me a difference of approx. 30 minutes.

When I don't add the UTC difference, the result has a huge...

But in my case, there was a difference of hours.

I have added UTC time difference. Now the difference is coming in minutes.

What should I do?