Date Issue

Question

Date Issue

Rohit Kulkarni 731

Hello Team I want to pass the date column in this format 'yyyymmdd'. I have passed this query in the lookup Activty UPDATE STG.WATERMARK SET ERDAT=formatDateTime('@{item().ERDAT}','yyyymmdd') WHERE DESTINATION_TABLE_NAME ='@{pipeline().parameters.DESTINATION_TABLE_NAME}' AND DESTINATION_TABLE_SCHEMA='S4' But the date is getting update in the column of the table 'YYYY-MM-DD' (2023-03-12). Please advise Regards Rohit

AnnuKumari-MSFT 34,571 Reputation points Microsoft Employee Moderator

2023-04-06T14:04:36.4033333+00:00

@Rohit Kulkarni , Just checking in to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'
AnnuKumari-MSFT 34,571 Reputation points Microsoft Employee Moderator

2023-04-24T07:18:32.8033333+00:00

Hi Rohit Kulkarni , Did the below answer helped resolve your issue? If yes, kindly accept the answer as accepted answer helps community. Thankyou

1 answer

Your answer

AnnuKumari-MSFT 34,571 Reputation points Microsoft Employee Moderator

2023-04-06T14:04:36.4033333+00:00

@Rohit Kulkarni , Just checking in to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'
AnnuKumari-MSFT 34,571 Reputation points Microsoft Employee Moderator

2023-04-24T07:18:32.8033333+00:00

Hi Rohit Kulkarni , Did the below answer helped resolve your issue? If yes, kindly accept the answer as accepted answer helps community. Thankyou

Answer 1

Hi Rohit Kulkarni , Thankyou for using Microsoft Q&A platform and thanks for posting your question here. As I understand your query, you are trying to update your sql table STG.WATERMARK to have data in ERDAT column in the format of yyyymmdd . In this process, the pipeline is successfully getting executed but the date column still holds the value in this format: YYYY-MM-DD . Please let me know if that's not the case.

The issue here is datatype mismatch. The column ERDAT is of Date datatype , which is always supposed to store the data in YYYY-MM-DD format.

It's not the issue with ADF pipeline. Even if you directly run the update query in the SQL table, you will find the same data is retaining without table getting updated . In order to store the data in any other format , kindly alter the column datatype as varchar with below command:

ALTER TABLE STG.WATERMARK
ALTER COLUMN ERDAT varchar(50);

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou

PRADEEPCHEEKATLA 91,866 Reputation points

2023-04-18T07:26:42.1666667+00:00

@Rohit Kulkarni - Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Date Issue

1 answer

Your answer