title: Kafka Connect date handling of debezium generated events
body: <p>I'm using debezium SQL Server to track changes on a production base.
  The topic is created, CDC is working like a charm, but when trying to use jdbcSinkConnector to dump the data in another Sql Server DB, I'm encountering the following error.</p>
  
  <p><code>com.microsoft.sqlserver.jdbc.SQLServerException: One or more values is out of range of values for the datetime2 SQL Server data type</code></p>
  
  <p>On the source database the sql datatype is <code>timestamp2(7)</code>.
  The kafka event is 1549461754650000000.
  The schema type is INT64.
  The schema name io.debezium.time.NanoTimestamp.</p>
  
  <p>I can't find a way to tell the TimestampConverter that is value isn't expressed in millis, or micros, but nanoseconds (would not work with microseconds anyway).</p>
  
  <p>here is my connector configuration</p>
  
  <pre><code>{
      "name": "cdc.swip.bi.ods.sink.contract",
      "config": {
          "connector.class": "io.confluent.connect.jdbc.JdbcSinkConnector",
          "tasks.max": "1",
          "topics": "swip.swip_core.contract",
          "connection.url": "jdbc:sqlserver://someip:1234;database=DB",
          "connection.user": "loloolololo",
          "connection.password": "muahahahahaha",
          "dialect.name": "SqlServerDatabaseDialect",
          "auto.create": "false",
          "key.converter": "io.confluent.connect.avro.AvroConverter",
          "value.converter": "io.confluent.connect.avro.AvroConverter",
          "key.converter.schemas.enable": "true",
          "key.converter.schema.registry.url": "http://localhost:8081",
          "value.converter.schemas.enable": "true",
          "value.converter.schema.registry.url": "http://localhost:8081",
          "transforms": "unwrap,created_date,modified_date",
          "transforms.unwrap.type": "io.debezium.transforms.UnwrapFromEnvelope",
          "transforms.created_date.type": "org.apache.kafka.connect.transforms.TimestampConverter$Value",
          "transforms.created_date.target.type": "Timestamp",
          "transforms.created_date.field": "created_date",
          "transforms.modified_date.type": "org.apache.kafka.connect.transforms.TimestampConverter$Value",
          "transforms.modified_date.target.type": "Timestamp",
          "transforms.modified_date.field": "modified_date",
          "insert.mode": "insert",
          "delete.enabled": "false",
          "pk.fields": "id",
          "pk.mode": "record_value",
          "schema.registry.url": "http://localhost:8081",
          "table.name.format": "ODS.swip.contract"
      }
  }
  </code></pre>