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

NishimuraChinatsu-9854 756 Reputation points
2023-07-27T06:25:03.02+00:00

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.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,145 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,407 Reputation points Microsoft Employee
    2023-07-27T21:58:45.05+00:00

    @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:

    User's image

    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.


0 additional answers

Sort by: Most helpful