Avatar

Employee Advisor

You are referring to ISO 8601 time, The Z suffix in the ISO 8601 time representation is sometimes referred to as "Zulu time" because the same letter is used to designate the Zulu time zone.

ISO 8601 - Wikipedia

Should get the following.

As for the extract, you need to use an expression with SQL, there are other ways, but this is the quickest I knew

In the column expression use the following, where GetDate() can be replaced with your tsColumnName (name of your field with timestampt) and append the Z manually for (ZULU timezone otherwise known as UTC )

[SQLDATA[CONVERT(VARCHAR(30), tsyourdatehere, 126)+'Z']]

1605732_pastedImage_0.png