Search Record from database in sql store procedure.

How to search record by date in sql stored procedure sql stored procedure.

ALTER Procedure [HMAMHUser].[sp_SrchPaymentsHistory]

(

@OrderDate datetime

)

select U.UserImage,U.FirstName,O.TransactionId,O.OrderDate,OT.TotalPriceAfterVAT

from OrderMaster as O

inner join UserProfileDetail U on U.UserId=O.UserId

inner join tblOrderDetail OT on OT.OrderId=O.OrderId

where OrderDate LIKE '%' +Convert(nvarchar(25),@OrderDate) + '%'

End

it's me code storeprocdure .

exec [sp_SrchPaymentsHistory] @OrderDate="2020-06-05 07:14:36.157 "- it's run successfully

But i want to this -

exec [sp_SrchPaymentsHistory] @OrderDate="06" .I have type only date not full datetime .

please provide solution.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar6y ago
Hi,
You have to convert or cast it. Then it will work.
Use the below query it will work.
exec [sp_SrchPaymentsHistory] @OrderDate=(SELECT CAST('2020-06-05 07:14:36.157' AS varchar(10)));
Thanks.
Amit Gupta6y ago
You have to concatenate the string with time in your SP. (Hard coded), if search is not bound of time then convert datatype (in query) to date only and perform search query