# JDBC Source Connector using a rowversion column for timestamp mode

**URL:** https://forum.confluent.io/t/jdbc-source-connector-using-a-rowversion-column-for-timestamp-mode/2104
**Category:** Self-Managed Connectors
**Created:** [24 June 2021 12:35 UTC](https://forum.confluent.io/t/jdbc-source-connector-using-a-rowversion-column-for-timestamp-mode/2104 "2021-06-24T12:35:41Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![batu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/batu/32/741_2.png) [@batu](https://forum.confluent.io/u/batu)
#### Post date: [24 June 2021 12:35 UTC](https://forum.confluent.io/t/jdbc-source-connector-using-a-rowversion-column-for-timestamp-mode/2104/1 "2021-06-24T12:35:41Z")

</div>

Hi,

Some of my tables in SQL Server only includes a timestamp(rowversion) column to specify the changes.  
I tried some type conversions like  
`"query":SELECT *, DATEADD(MILLISECOND,CAST(Timest AS bigint),CAST('1900-01-01 00:00:00.0000000' AS datetime2)) AS MyNewDatetime FROM ProductPrice`

But id didn’t worked as expected:)

Is it possible to use this unique binary column on jdbc source connector with any mode or am i trying the impossible?

Thanks.

---

<div class="post-metadata">

### Author: ![batu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/batu/32/741_2.png) [@batu](https://forum.confluent.io/u/batu)
#### Post date: [16 July 2021 18:10 UTC](https://forum.confluent.io/t/jdbc-source-connector-using-a-rowversion-column-for-timestamp-mode/2104/2 "2021-07-16T18:10:25Z")

</div>

I solved it with a subselect query which basically adds a new datetime2 column to my query results. With this approach i can use any rawversion or unique binary columns for `mode:timestamp`.

Here is my full config 📎

```auto
 "config": {
            "connector.class" : "io.confluent.connect.jdbc.JdbcSourceConnector",
            "connection.url" : "jdbc:sqlserver://localhost:1433;databaseName=TestDB;",
            "connection.user" : "User",
            "connection.password" : "Password",
            "numeric.mapping" : "best_fit",
            "tasks.max" : "1",
            "name" : "test1",
            "mode" : "timestamp",
            "query" : "SELECT * FROM (select *,DATEADD(MILLISECOND,CAST(Timest AS bigint),CAST('1900-01-01 00:00:00.0000000' AS datetime2)) AS MyNewTimeStamp FROM Price) X",
            "timestamp.column.name" : "MyNewTimeStamp",
            "table.types" : "TABLE",
            "topic.prefix" : "jdbc_sqlserver_",
            "validate.non.null" : "false",
            "topic.creation.enable" : "true",
            "topic.creation.default.replication.factor" : "3",
            "topic.creation.default.partitions" : "3"
  }

```

---

<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: [23 July 2021 18:11 UTC](https://forum.confluent.io/t/jdbc-source-connector-using-a-rowversion-column-for-timestamp-mode/2104/3 "2021-07-23T18:11:13Z")

</div>

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