Format utcnow() in Azure Data Factory

Viewed 4696

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.

1 Answers

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

Related