dotnetcore / dotnetcore/FreeSql

GBase V3.5.210 时间类型字段类型带精度生成的sql ,南大通用执行sql就会报错

Open
#2,079 0 comments 0 reactions 0 assignees View on GitHub
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 就报错

Image

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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.