CODEWITHSUNDEEP
azureazure-data-factory
Azim Kamal
Azim Kamal

Reputation: 143

Format utcnow() in Azure Data Factory

How can I format dynamic content utcnow() to something like this “2021-06-01 13:42:59” in ADF. I have tried “yyyy-MM-dd HH:mm:ss” but it doesn’t work.

Upvotes: 6

Views: 23780

Answers (1)

Anupam Chand
Anupam Chand

Reputation: 2662

As @Joel mentioned, you can use the inbuilt date function utcnow(). Click on "Add dynamic content" and select the "utcnow" under the date functions. Then add the formatting like 'yyyy-MM-dd HH:mm:ss' within the braces. Eventually you should have something like the attached picture.Dynamic content Date function utcnow final setting

Upvotes: 8

Related Questions