dotnetcore / dotnetcore/FreeSql
GBase V3.5.210 时间类型字段类型带精度生成的sql ,南大通用执行sql就会报错
- Dominant language
- C#
- Stars
- 4.4k
- Forks
- 910
- PR merge metrics
- No merged PRs in 30d
Description
#### 问题描述及重现代码:
带精度的时间类型生成sql后是 UpdateTime = '2025-07-19 14:08:30.340' GBase 就报错
GBaseAdo.cs 和 GBaseUtils.cs
```c#
else if (param is DateTime)
return AddslashesTypeHandler(typeof(DateTime), param) ?? (mapColumn?.DbPrecision > 0 ?
string.Concat("'", ((DateTime)param).ToString($"yyyy-MM-dd HH:mm:ss.{"f".PadRight(mapColumn.DbPrecision, 'f')}"), "'") :
string.Concat("'", ((DateTime)param).ToString("yyyy-MM-dd HH:mm:ss"), "'"));
else if (param is DateTime?)
return AddslashesTypeHandler(typeof(DateTime?), param) ?? (mapColumn?.DbPrecision > 0 ?
string.Concat("'", ((DateTime)param).ToString($"yyyy-MM-dd HH:mm:ss.{"f".PadRight(mapColumn.DbPrecision, 'f')}"), "'") :
string.Concat("'", ((DateTime)param).ToString("yyyy-MM-dd HH:mm:ss"), "'"));
```
当前处理是移除了带精度的这段,要它直接生成"yyyy-MM-dd HH:mm:ss"
#### 数据库版本
GBASE 8.8S
#### 安装的Nuget包
V3.5.210
#### .net framework/. net core? 及具体版本
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.