Question

1
Replies
205
Views
Close popover
Praveen Mohan (PraveenMohan)
Allianz SE

Allianz SE
IN
PraveenMohan Member since 2015 38 posts
Allianz SE
Posted: April 9, 2019
Last activity: April 9, 2019
Closed

Sql query with date

Hi All,

We have a requirement to clear the instances of a table which are older than one week. I have created an agent activity and using RDB-Delete method. But while testing its throwing the below error.

SQl Query: delete from Data.pr_MyTablel_Con_0620d where ExpiryDateTime < {ASIS:ConnectLog.pxCreateDateTime};

Value of ConnectLog.pxCreateDateTime property in clipboard is 20190402T000000.000 GMT

Error:

 There was a problem getting a list: code: 102 SQLState: S0001 Message: Incorrect syntax near 'T000000'. 
Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.