CODEWITHSUNDEEP
azure-pipelinesazure-data-factory
Ashok Kumar Bollineni
Ashok Kumar Bollineni

Reputation: 29

How to display date like NOVEMBER 13, 2020 in azure data factory using mapping dataflow?

I want to display date like NOVEMBER 13,2020. Requesting you to suggest how can i achieve it using azure data factory mapping dataflow.

Thanks in Advance!!

Regards, Ashok

Upvotes: 0

Views: 113

Answers (2)

Kiran-MSFT
Kiran-MSFT

Reputation: 234

You should use toString(dateCol, 'with date format'). You can find all date formats from https://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html

You can use 'L' and experiment with what format you desire.

Upvotes: 0

Leon Yue
Leon Yue

Reputation: 16411

You can use Data Flow to achieve that.

Create a Source with your data like this: enter image description here

Please set the data "2020-02-12" as String data.

Then using Derived column to build the expression to achieve that output:

concat(case(month(toDate(d))==1,'January',month(toDate(d))==2,'February',month(toDate(d))==3,'March',month(toDate(d))==4,'April',month(toDate(d))==5,'May',month(toDate(d))==6,'June',month(toDate(d))==7,'July',month(toDate(d))==8,'August',month(toDate(d))==9,'September',month(toDate(d))==10,'October',month(toDate(d))==11,'November',month(toDate(d))==12,'December'),',' ,toString(dayOfMonth(toDate(d))),',',toString(year(toDate(d))))

enter image description here

enter image description here

enter image description here

After doing this, you can get the output you want.

HTH.

Upvotes: 2

Related Questions