How to retrieve records for last 30 minutes in MS SQL

Question

I want to retrieve records for last 30 minutes in a table  How to do that  Below is my query    select   from  Janus999DB   dbo   tblCustomerPlay  where DatePlayed  lt  CURRENT TIMESTAMP and DatePlayed  gt   CURRENT TIMESTAMP-30

User · Accepted Answer

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

User · Answer

Remember that CURRENT TIMESTAMP -  number  works fine  but that you need to understand what number it is looking for - it is floating-point number of days  So CURRENT TIMESTAMP-1 0 is 1 day ago  CURRENT TIMESTAMP-0 5 is 1 2 day ago  For 30 minutes  that is 1 0 48 0  use radix so result is a floating point number  or 0 0208333333333333  so your query will work if re-written as   select   from  Janus999DB   dbo   tblCustomerPlay  where DatePlayed  lt  CURRENT TIMESTAMP and DatePlayed  gt  CURRENT TIMESTAMP-1 0 48 0   You could also use 1 0 24 0 2 0 if that looks more like 1 2 hour to you

User · Answer

Use   SELECT    FROM  Janus999DB   dbo   tblCustomerPlay   WHERE DatePlayed  lt   GetDate    AND DatePlayed  gt  dateadd minute  -30  GetDate

User · Answer

DATEADD only returned Function does not exist on MySQL 5 5 53  I know it s old   Instead  I found DatePlayed  gt  DATE SUB CURRENT TIMESTAMP  INTERVAL 30 minute  to produce the desired result

User · Answer

Have a look at using DATEADD  something like  SELECT DATEADD minute  -30  GETDATE

User · Answer

SQL Server uses Julian dates so your 30 means  30 calendar days    getdate   - 0 02083 means  30 minutes ago

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

Examples related to sql

Examples related to sql-server

Examples related to tsql