... DATEDIFF(minute, GETDATE(), deactivcationdate) <= 15...
SELECT customer_id, customer_name FROM mstCustomers WHERE DATEDIFF(minute, GETDATE(), deactivation_date) <= 15
SELECT * FROM MyTable WHERE deactivation_date < DATEADD(minute, -15, GETDATE())
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)