Harish Batchu

Harish Batchu

  • NA
  • 255
  • 70.9k

Check otp with in 5 min in MSSQL query

Jun 26 2019 5:50 AM
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)