How to convert time zone of date time?

[Anonymous]

I'm reading data from Cosmos DB. I have there EventProcessedUTCTime from Stream Analytics.

How to convert datetime to time zone -2h.

[v-eachen-msft]

Hi @Anonymous ,

You could open query editor and use custom column with the following codes:

[Your datetime]-#duration(0,2,0,0)

Then you could delete original column and keep this custom column in your table.

[Anonymous]

I'm getting following errror. Please advice.

Expression.Error: We cannot apply operator - to types Record and Duration.
Details:
Operator=-
Left=
Document.EventProcessedUtcTime=18.11.2019 15.07.38
Right=0.02:00:00

[az38 · Accepted solution]

@Anonymous 

why do you have double symbols [[ and ]]? try to clear to format 

[Document.EventProcessedUtcTime]-#duration(0,2,0,0)

do not hesitate to kudo useful posts and mark solutions as solution
Linkedin

[v-eachen-msft]

Hi @Anonymous ,

Is the type of column date/time? If not, please change it to date/time type at first.

[az38]

hi @Anonymous 

create calculated column

Column = 'Table'[DateTime]-time(2;0;0)

do not hesitate to kudo useful posts and mark solutions as solution
Linkedin