Converting datetime to date in ADF Mapping?

0
votes

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

1
mappingazure-data-factory
Can you consider copying to the Azure SQL table first? Then copying to the txt file. – Joseph Xu
Synapse workspaces have dataflows in gov cloud – Kiran-MSFT

1 Answers

2
votes

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