SqlServer CDC Reader

{
    "type":"update",
    "schema":"dbo",
    "table":"tb1",
    "lsn":"00000032:00002038:0005",
    "ts": 6760525407742726144,
    "before_id":1,
    "after_id":2
}

{
    "type":"update",
    "schema":"dbo",
    "table":"tb1",
    "lsn":"00000032:00004a38:0007",
    "ts": 6760525407742726144,
    "before":{
        "id":1
    },
    "after":{
        "id":2
    }
}

long id = Long.parseLong("6760525407742726144");
        long res = id >> 22;
        DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        System.out.println(sdf.format(res));		//2021-01-28 19:54:21

{
  "job" : {
    "content" : [ {
      "reader" : {
        "parameter" : {
          "username" : "uname",
          "password" : "passwd",
          "url": "jdbc:sqlserver://host:1433;database=databaseName",
          "databaseName":"databaseName",
          "tableList": ["dbo.cdc"],
          "lsn": "00000025:00000bc0:0003",
          "cat": "insert,update,delete"
        },

        "name" : "sqlservercdcreader"
      },
      "writer": {
        "name": "streamwriter",
        "parameter": {
          "print": true
        }
      }
    }
    ],
    "setting" : {
      "restore": {
        "isStream": true
      },
      "speed" : {
        "channel" : 1
      }
    }
  }
}