- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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.
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']]
Views
Replies
0 Likes
Total Likes