Stored Procedure

[Bryan Batts]

Hello All,

I'm having trouble with the below stored proc.

delimiter //

drop procedure if exists sp_BlogsGet_DateTime//
create procedure sp_BlogsGet_DateTime
(
SBlogDate varchar(19),
EBlogDate varchar(19)
)
begin
select * from Blogs where (PublishDate > @SBlogDate and PublishDate < @EBlogDate);
end//

When I call it from my asp.net application is returns no records. However, If i copy the exact same query and run it as a command text, it get the desired results.

Any ideas?

Thanks in advance for you help.