日期+时间段检索的SQL语句(存储过程)

CREATE PROCEDURE sp_vProducts_GetProducts
@startDateTime varchar(50),
@endDateTime varchar(50)
AS
SELECT vProducts.BeginningYear + '/' + vProducts.BeginningMonth + '/' + vProducts.BeginningDay + ' ' + vProducts.BeginningHour + ':' + vProducts.BeginningMinute AS BeginningDay
FROM vProducts
WHERE vProducts.BeginningYear + vProducts.BeginningMonth + vProducts.BeginningDay + vProducts.BeginningHour + vProducts.BeginningMinute > @startDateTime and BeginningYear + vProducts.BeginningMonth + vProducts.BeginningDay + vProducts.BeginningHour + vProducts.BeginningMinute < @endDateTime
GO

两个变量格式必须是200706021532这种格式，代表2007年6月2日15点32分