Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Timestamp format in Incremental Import of DB Connector

sdey_2023
New Contributor III
New Contributor III

Hi,

We are trying to perform incremental import from authoritative source (SQL database) and have two queries related to the same:

1. We need to know the format of the "updatedate" column in the DB table/view. In the documentation portal it is mentioned as yyy-mm-dd hh:mm:ss.0 (3 y's for year) but it seems not correct, could you please confirm the if the format should be yyyy-mm-dd hh:mm:ss.0(4 y's for year). 

2. Do the column name in the Databse table need to be "updatedate" only or it can be any other name as well like "Last update timestamp"?

Thanks.

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

target column name should be updatedate (know defect ) 

its typo it should be 4 y @uthra_rahul 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

sangitaladi
Regular Contributor
Regular Contributor

thank you

Share link where you found typo


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.