How to convert to datetime type in mapping?

Question

How to convert to datetime type in mapping?

Kakehi Shunya (筧隼弥) 201

I am developing a pipeline in Azure Synapse to convert a jason file downloaded via api call into a parquet.
The column names are lastModDate and lastModifiedDate and I want to store these in the sink as Datetime or DatetimeOffset type, but I got an error.
The data is converted correctly in the data preview, but what should I do in the copy activity?

1 answer

Your answer

Answer 1

ShaikMaheer-MSFT 38,546 Microsoft Employee Moderator

Hi @Kakehi Shunya (筧隼弥) ,

Thank you for posting query in Microsoft Q&A Platform.

While loading source data to Sink you can define format of datetime data which you have in source to avoid formatting and conversion issues.

Please check below screenshot, here we are defining source date format.

Hope this helps. Kindly try above and let me how it goes.

----------

Please consider hitting Accept Answer button. Accepted answers help community as well.

Kakehi Shunya (筧隼弥) 201 Reputation points

2022-11-15T10:29:50.713+00:00

Thank you for your answer.

I see that the copy activity map does indeed have that feature, but I'm a newbie and don't know how to specify the format.
What I want to achieve this time is to convert jason's date type.
Any more specific help would be appreciated.

Thank you.
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2022-11-15T15:44:47.397+00:00

HI @Kakehi Shunya (筧隼弥) , Based on the format in which your data coming from JSON same format you need to define there. For example, if you are getting value in source as 2022-03-13T19:25:56 then you should write format as yyyy-MM-ddTHH:mm:ss.

Hope this helps. Please consider hitting Accept Answer. Accepted answers help community as well.
Kakehi Shunya (筧隼弥) 201 Reputation points

2022-11-16T11:13:19.78+00:00

I tried it, but it didn't work.

Share via

How to convert to datetime type in mapping?

1 answer

Your answer