How extracting the year of a date in a data pipeline

[pmscorca]

Hi,

in a data pipeline I'd like to extract the year from a date (f.e. the actual date) and add a related custom column.

Looking the Azure Data Factory functions it seems that a such funtion doesn't exist.

Any suggests to me, please? Thanks

[NandanHegde · Accepted solution]

please refer the below blog :

https://azurelib.com/datetime-conversions-in-azure-data-factory/

you can use formatdatetime as per 'yyyy'