两者之间，和 单一

IF(ISNULL(@ShipConfirmDate,'')!='')
BEGIN
IF (len(@ShipConfirmDate)<38)
SET @ShipConfirmDate='AND ShipConfirmDate='''+@ShipConfirmDate+''''
ELSE
DECLARE @StartTime NVARCHAR(2000)
DECLARE @EndTime NVARCHAR(2000)
SET @StartTime=SUBSTRING(@ShipConfirmDate,0,11)
SET @EndTime=SUBSTRING(@ShipConfirmDate,21,11)
SET @ShipConfirmDate=' AND ShipConfirmDate between '''+''+CONVERT(nvarchar(10),@StartTime, 20)+''+''' AND '''+''+CONVERT(nvarchar(10), @EndTime, 20)+''+''''
END