1
Answer

Check otp with in 5 min in MSSQL query

Harish Batchu

Harish Batchu
5y
1.5k
1
I write below query to get check otp with in five minuites but i thought it will wrong can any one help
 
 
select * from Customer where Phone='7873498489' and Otp=2032 and CURRENT_TIMESTAMP >= OtpCreateDate - 5/(24*60) 
Answers (1)
Next Recommended Forum