[Bug] [connector-jdbc-sqlserver] SQLServer datetimeoffset should be mapped to OffsetDateTime instead of LocalDateTime
- Dominant language
- Java
- Stars
- 9.7k
- Forks
- 2.4k
- Avg merge
- 3d 13h
- Merged PRs (30d)
- 203
Description
### Search before asking
- [x] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues.
### What happened
SqlServerTypeConverter.java
```java
case SQLSERVER_DATETIMEOFFSET:
builder.sourceType(
String.format("%s(%s)", SQLSERVER_DATETIMEOFFSET, typeDefine.getScale()));
builder.dataType(LocalTimeType.LOCAL_DATE_TIME_TYPE);
builder.scale(typeDefine.getScale());
break;
```
This is incorrect. Should be `LocalTimeType.OFFSET_DATE_TIME_TYPE`. Same in test.
### SeaTunnel Version
latest
### SeaTunnel Config
```conf
unrelated
```
### Running Command
```shell
unrelated
```
### Error Exception
```log
no exception
```
### Zeta or Flink or Spark Version
_No response_
### Java or Scala Version
OpenJDK 21
### Screenshots
_No response_
### Are you willing to submit PR?
- [x] Yes I am willing to submit a PR!
### Code of Conduct
- [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.