I would like to know about timestamps in derived columns of synapse dataflow.

Question

I want to display fromUTC(currentUTC(),'Asia/Tokyo') as yyyy-mm-ddTHH:mm:ss in the derived column of synapse dataflow.

fromUTC(currentUTC(),'Asia/Tokyo') is yyyy-MM-ddTHH:mm:ss.ffffffffK.

Answer 1

@NishimuraChinatsu-9854 Thanks for using Microsoft Q&A forum and posting your query.

In order to format the datetime to yyyy-mm-ddTHH:mm:ss , you can use subString() function as shown below:

substring(toString(fromUTC(currentUTC(),'Asia/Tokyo')), 1,19)

Below is a sample result of the test:

Hope this info helps.

---

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.