'Formatting Time without colon in Azure Data Factory (Java SimpleDateFormat)

I'd like to format a timestamp like yyyy-MM-dd'T'HH-mm-ss as using colons causes issues when reading through ADF.

I'm writing it in ADF which uses Java SimpleDateFormat - can't seem to find anywhere in docs about writing a timestamp like this.

Is it possible and if so, how?



Solution 1:[1]

In Azure DataFlow, for individual items of time/date, use as follows :

year(currentDate())
month(currentDate())
dayOfMonth(currentDate())
hour(currentUTC())
minute(currentUTC())
second(currentUTC())

Concat and use as required.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1