Forum Discussion

h4tt3n's avatar
h4tt3n
Icon for Helper V rankHelper V
6 years ago

Convert a columns of datatype datetimezone to datetime

Hello,   I have a table with timestamped data of datatype datetimezone, eg. 07-08-2020 08:00:00 + 02:00.  How do I convert this to datetime in a way that takes tz info into account, eg. 07-08-2020...
Need Help
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi h4tt3n 

 

Convert into datetime but add another step

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjDXNbDQNTIwMlAwsLAyMAAiBW0DIyClFBsLAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type datetimezone}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Column1", type datetime}})
in
    #"Changed Type1"
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

h4tt3n's avatar
h4tt3n
Icon for Helper V rankHelper V
6 years ago

I have tried to add the conversion as another step, but unfortunately this doesn't work either. Challenge remains unsolved.