在我的存储过程中,我有一个DATE类型的参数,并具有一个值'2022-3-8'。DECLARE @d DATE = '2022-3-8'
FROM Readings AS r
WHERE CONVERT(VARCHAR我想删除时间组件,并比较'2022-03-08'和'2022-3-8'。注意月号和日数中的零。
shapes must be fully defined: %s" % shapes)
ValueError: All shapes must be fully defined: [TensorShape([Dimension(None), Dimension(None), Dimension(3)]), TensorShape([])]
[width] >= dimension.[length] and dimension.[width] >= dimension.height then dimension.[length] <= dimension.width and dimension.[length] >= dimension.height) then dimension.[height] <= dimension.[length
下面是我的存储过程(sp_DATE_DIMENSION),它接受两个参数,以及我已经创建的DATE_DIMENSION表的定义。CREATE OR REPLACE PROCEDURE sp_DATE_DIMENSION(v_START_YEAR IN INT, v_END_YEAR IN INT) AS
v_CURRENT_DATE;
WHILE v_CURREN