Question

1
Replies
260
Views
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
Posted: 9 Apr 2019 5:06 EDT
Last activity: 9 Apr 2019 9:21 EDT
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, 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.