search

dotnetcore / CAP

Distributed transaction solution in micro-service base on eventually consistency, also an eventbus with Outbox pattern
http://cap.dotnetcore.xyz
MIT License
6.61k stars 1.28k forks source link

DaMeng Database: DeleteExpiresAsync sql Datetime auto format AM/PM #1564

Closed pccai closed 1 month ago

pccai commented 1 month ago

DELETE FROM cap.published WHERE ExpiresAt < '7/17/2024 11:56:57 AM' AND (StatusName='Succeeded' OR StatusName='Failed') limit 1000;

This Causing some database incompatibility.

Ubuntu 22.04/Net8

yang-xiaodong commented 1 month ago

What's your database and version?

pccai commented 1 month ago

DM8

yang-xiaodong commented 1 month ago

这和CAP无关，DateTime我们并没有格式化为string然后拼接的sql，而是使用的 SqlParameter 传递的 DateTime 类型，所以对于DateTime的使用这取决于数据库驱动的实现问题。