Timestamp format in Incremental Import of DB Connector

[sdey_2023]

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.

[rushikeshvartak · Accepted solution]

target column name should be updatedate (know defect ) 

its typo it should be 4 y @uthra_rahul 

[sangitaladi]

thank you

[rushikeshvartak]

Share link where you found typo

[sdey_2023]

Database Connector Guide : Customer Portal (freshdesk.com)