问Server中调用Oracle数据库的存储过程中的日期错误

EN

DECLARE
    @IntStartDate Varchar(50),
    @IntEndDate Varchar(50),
    @ConStartDate Varchar(50),
    @ConEndDate Varchar(50),
    @Query Varchar(Max)

--Convert SQL to UNIX Time
SET @IntStartDate = CONVERT(varchar(50), @StartDate, 23)
SET @IntEndDate = CONVERT(varchar(50), DATEADD(day, 1, @EndDate), 23)

SET @ConStartDate = (DATEDIFF(SECOND,'1970-01-01', @IntStartDate))
SET @ConEndDate = (DATEDIFF(SECOND,'1970-01-01', @IntEndDate ))

SET @Query = 'select * 
              from openquery([linkedserver],
''
SELECT 
sm.movement_type as "Movement Type",
sm.reference as "RMA Number",
cri.reason_code as "RMA Reason",
cri.sales_document_num as "Order Number",
sh.customer_account as "Customer Account",
sm.product_code as "SKU",
cri.long_description_1 as "Product Name",
to_char(trunc(date ''1970-01-01'' + sm.movement_date * interval ''1'' second),''DD/MM/YYYY'') as "Movement Date",
sm.quantity as "Quantity",
sm.change_user as "User",
sm.warehouse_code as "Warehouse",
sm.receipt_location as "Location"
FROM
STOCK_MOVEMENT SM
left join CUSTOMER_RETURN_ITEM CRI on sm.reference = cri.rma_num
left join sales_header sh on cri.sales_document_num = sh.sales_document_num
WHERE sm.reference like ''5%''
AND sm.change_user not in (''l.hill'', ''d.newell'', ''p.willman'', ''s.parkinson'')
AND sm.movement_type = ''RMASTK''
AND sm.movement_date  BETWEEN ' + cast(@ConStartDate as varchar)+ ' and ' + cast(@conEndDate as varchar) + '

'')
'