# What is column data type in sybase compatible with kafka connect timestamp

**URL:** <https://forum.confluent.io/t/what-is-column-data-type-in-sybase-compatible-with-kafka-connect-timestamp/7176>\
**Category:** Kafka Connect\
**Created:** [7 February 2023 09:19 UTC](https://forum.confluent.io/t/what-is-column-data-type-in-sybase-compatible-with-kafka-connect-timestamp/7176 "2023-02-07T09:19:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![abhinavsaxena18](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@abhinavsaxena18](https://forum.confluent.io/u/abhinavsaxena18)\
**Post date:** [7 February 2023 09:19 UTC](https://forum.confluent.io/t/what-is-column-data-type-in-sybase-compatible-with-kafka-connect-timestamp/7176/1 "2023-02-07T09:19:25Z")

</div>

What is column data type in sybase compatible with kafka connect timestamp ?

as i have tried datatime ,timestamp data type in sybase but i am getting below error

[2023-02-06 11:19:22,840] ERROR [jdbc\_source\_sybase\_01|task-0] Failed to get current time from DB using Generic and query ‘SELECT CURRENT\_TIMESTAMP’ (io.confluent.connect.jdbc.dialect.GenericDatabaseDialect:564)  
**java.sql.SQLException: Invalid column name 'CURRENT\_TIMESTAMP** ’.

my sample json for kafka connect mentioned below

{  
“name”: “jdbc\_source\_sybase\_02”,  
“config”: {  
“connector.class”: “io.confluent.connect.jdbc.JdbcSourceConnector”,  
“connection.url”: “jdbc:sybase:Tds:xxxxx-yyyy:port/schema”,  
“connection.user”: “xxxx”,  
“connection.password”: “xxxxx”,  
“topic.prefix”: “test\_query\_mode”,  
“mode”: “timestamp”,  
“timestamp.column.name”: “dt\_chg\_lst”,  
“poll.interval.ms” : 30000,  
“query”: “select dt\_chg\_lst,fname from CUSTOMER”,  
“catalog.pattern” : “PYR\_TRADE”  
}  
}

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)\
**Post date:** [9 March 2023 09:19 UTC](https://forum.confluent.io/t/what-is-column-data-type-in-sybase-compatible-with-kafka-connect-timestamp/7176/2 "2023-03-09T09:19:54Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.