getdate and sql coulmn sms_date check 20 min

Hi, you can try this,

 

IF EXISTS ( SELECT * from insertsmsLog where SMS_MobileNumber=@Mobileno and SMS_OTP=@smsotp

and SMS_ApplicationNumber=@Priciapalid

and DATEDIFF(MINUTE, Convert(datetime,SMS_Date),GETDATE())<=20)

BEGIN

   -- 

   --Some Code

   -- 

END

ELSE

BEGIN

   -- 

   --Wrong OTP

   -- 

END

It will check if OTP is less than or equal to '20' Minutes otherwise it will say the wrong OTP you can change the value of minutes there like 20, 10, or 5 minutes.

 

Please make sure you have DateTime datatype for the SMS_Date Column in database.