CODEWITHSUNDEEP
mappingazure-data-factory
Mike Kiser
Mike Kiser

Reputation: 33

Converting datetime to date in ADF Mapping?

I have a requirement for the final output text delimited document to contain only dates, however the json which I am reading as the Source in my ADF Copy Activity has the datetime fields as "hireDate": "1988-03-28T00:00:00+00:00", for example; I need these to be "1988-03-28". Any suggestions on doing this in the ADF Mapping (and we don't have Data Flow Mapping in the government Azure Cloud). Thank you Mike Kiser

Upvotes: 0

Views: 884

Answers (1)

Joseph Xu
Joseph Xu

Reputation: 6043

No choice, we need an intermediate process, eg: We can copy the json file into a Azure SQL table, then copy from Azure SQL into a txt file.

  1. Create a table and set the column type to date.
create table dbo.data1(
    hireDate date
)

  1. Copy into the table. It automatically casts the type from datetime to date . enter image description here

  2. The debug result is as follows:
    enter image description here

Upvotes: 2

Related Questions