How to retrieve records for last 30 minutes in MS SQL?

Have a look at using DATEADD

something like

SELECT DATEADD(minute, -30, GETDATE())

Change this (CURRENT_TIMESTAMP-30)

To This: DateADD(mi, -30, Current_TimeStamp)

To get the current date use GetDate().

MSDN Link to DateAdd Function
MSDN Link to Get Date Function

Related