ClickHouse:求助,日期范围查询异常,生成的sql不对吗? 返回

SqlSugar 处理完成
76

-----------------请忽略吧------------------------------------------------

sql 写错了!

image.png

————————————————————————————————————————————

版本:

    <PackageReference Include="SqlSugar.ClickHouseCore" Version="5.1.4.137" />

    <PackageReference Include="SqlSugarCore" Version="5.1.4.146" />

代码:

image.png


语句:

image.png


结果:

Code: 43. DB::Exception: Illegal type DateTime of first argument of function parseDateTimeBestEffort: While processing SELECT count() FROM Fin_PositionStock WHERE (CutOffTime >= parseDateTimeBestEffort(_CAST(1711900800, 'DateTime'))) AND (CutOffTime <= parseDateTimeBestEffort(_CAST(1711987199, 'DateTime'))) AND (OwnerCode = _CAST('MY-004', 'String')) AND (WarehouseCode = _CAST('MYCK', 'String')) AND (BusinessCode = _CAST('177', 'String')) AND (StockCount > _CAST(10, 'Int32')). (ILLEGAL_TYPE_OF_ARGUMENT) (ve


热忱回答0