JDBC Plugin Default Timezone Milliseconds Value not Persisting

Elastic Stack Logstash
1

I am trying to ingest data from a sql database that has a field of type datetime2. When the data is ingested into logstash via the JDBC input plugin, it will auto-correct the format based on the host's local timezone (if the local timezone was New York, then it would add +4 hours to the hour field in the data).

To correct for that, there is a nice value you can set called "jdbc_default_timezone". If you set this value to be "UTC" it will then prevent the addition on the hours value as you are taking in data. However, when doing so it completely forgets the value of the milliseconds that were originally present in the sql database data!

The configuration I'm currently using can be found below:

input {
  jdbc {
    jdbc_driver_library => "path\sqljdbc4.jar"
    jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    jdbc_connection_string => "jdbc:sqlserver://name\server:port;databaseName=dbName"
    jdbc_user => "user"
    jdbc_password => "pass"
    statement => "SELECT * FROM Table1 JOIN Table2 on Table1.Field=Table2.Field WHERE Table1.Field BETWEEN value1 AND value2"
    jdbc_default_timezone => "UTC"
  }      
}

Any help or thoughts are greatly appreciated,

Rob