Question

1
Replies
128
Views
PraveenMohan Member since 2015 37 posts
Allianz SE
Posted: 1 year ago
Last activity: 1 year 5 months ago
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
Share this page LinkedIn