Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Praveen Mohan (mohap3)
PEGA
Senior Software Engineer, Agile Tooling
Pegasystems Inc.
IN
mohap3 Member since 2021 39 posts
PEGA
Posted: Apr 9, 2019
Last activity: Apr 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'.

To see attachments, please log in.
Data Integration

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice