mysql - SQL Reporting Services 中 MySql 查询的日期语法

Question

我当前正在尝试将 mysql 存储过程链接到 Microsoft SQL 报告服务器。它出现语法错误。我相信这取决于 Date_from 和 Date_to 参数。查询如下，如有帮助，将不胜感激

DELIMITER $$

USE `mydb`$$

DROP PROCEDURE IF EXISTS `DTI`$$

CREATE DEFINER=`linkeduser`@`%` PROCEDURE `DTI`(IN date_from DATETIME,
IN date_to DATETIME)

BEGIN

  SELECT title,gender,firstname,lastname,address1,town,postcode,dob,IF(co.start_date = '00-00-0000', '', CAST(DATE(co.start_date) AS DATE)) AS 'StartDate' 

  FROM cf_user AS us
JOIN ca_compliance AS co ON co.user_id = us.user_id

WHERE co.start_date BETWEEN date_from AND date_to; 
END$$

DELIMITER ;

Answer 1

只是因为似乎没有人愿意帮助我设法解决我的销售问题="CALL sproc_PackOut('"& Format(Parameters!DateFrom.Value, "yyyy-MM-dd 00:00:00") & "','"& Format(Parameters!DateTo.Value, "yyyy-MM-dd 00:00:00") & "','"& Format(Parameters!DateTo.Value, "yyyy-MM-dd 00:00:00") 23:59:59") & "')"