在我的存储过程中,我有一个DATE类型的参数,并具有一个值'2022-3-8'。DECLARE @d DATE = '2022-3-8'
FROM Readings AS r
WHERE CONVERT(VARCHAR我想删除时间组件,并比较'2022-03-08'和'2022-3-8'。注意月号和日数中的零。
*在c:\ Autodesk.AutoCAD.EditorInput.Editor.Command(Object[] \Autodesk.AutoCAD.EditorInput.Editor.Command(Object[]\Documents\All Code\autocad-adapter\IOAutoCADHandler\myCommands.cs:line 186 at Autodesk.AutoCAD.Runtime.CommandClass.InvokeWorker(MethodInfo mi,Object c