How to convert timestamp from utc to +10

Ivan Vasenev 5

I have a problem. Don't know how to convert timezone to mine

Erland Sommarskog 133.1K Reputation points MVP Volunteer Moderator

2025-09-03T21:39:52.06+00:00

And just to double-check: You are asking how to do this in Analysis Services?

(I could help if you need to do it in T-SQL, but I don't know SSAS.)

Answer recommended by moderator

Dinesh Yadlapalli 85 Reputation points Microsoft External Staff Moderator

2025-10-23T11:47:38.5533333+00:00
Hi @Ivan Vasenev ,

Thank you for reaching out to the Microsoft Q & A Forum.

As you mentioned in your question, you want convert timestamp from UTC to +10. Please refer below workarounds.

In SQL server, you can try below two queries to get the desired result.

Query 1:

SELECT

ID, UTCDateTime AS OriginalUTC, DATEADD(HOUR, 10, UTCDateTime) AS ConvertedToUTCPlus10

FROM SampleUTCData;

Query 2:

SELECT

GETUTCDATE() AS CurrentUTC, DATEADD(HOUR, 10, GETUTCDATE()) AS CurrentUTCPlus10;

Please refer below output snap.

In SSAS tabular model, please try below calculated column by using DAX code

UTCPlus10 = DATEADD(YourTable[UTCDateTime], 10, HOUR)

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh
Please sign in to rate this answer.
Dinesh Yadlapalli 85 Reputation points Microsoft External Staff Moderator

2025-10-27T03:57:19.68+00:00

Hi @Ivan Vasenev ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

0 additional answers

Your answer