How to display date and time in UTC format i.e, 2018-05-02T13:47:33.743Z? | Community
Skip to main content
New Participant
Jan 29, 2020 10:02 AM UTC
Solved

How to display date and time in UTC format i.e, 2018-05-02T13:47:33.743Z?

I have an Export workflow, that extracts data from tracking logs and recipient schema and is storing the data in a .csv file. I have a requirement that while extracting date-time data we should be displaying in file (example as 2018-05-02T13:47:33.743Z) this.

 

In Classic i could do something like this: [SQLDATA[CONVERT(VARCHAR(30), tsyourdatehere, 126)+'Z']]

 

But that is not possible in Standard.

 

Thanks 🙂

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
henrikm69539229Accepted solution
New Participant
Jan 29, 2020 12:33 PM UTC

1 reply

henrikm69539229AuthorAccepted solution
New Participant
Jan 29, 2020 12:33 PM UTC

Translate