CODEWITHSUNDEEP
sql-serverpowerpivot
muttley91
muttley91

Reputation: 12674

Get Data From Last 48 Hours

I'm using PowerPivot with an SQL Server database and I'm working with a specific table that includes a DateTime column. I'd like to select the data from the table where that DateTime is within the last 48 hours. I'm using a query currently and hoping to achieve something like

... WHERE DT > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL +2 DAY)

I'm getting a syntax error at DAY in this particular way. Is this the best way to do it? If so, what's wrong with how I've written it? If not, what's a better way?

Upvotes: 3

Views: 12333

Answers (1)

M.Ali
M.Ali

Reputation: 69494

Sql-Server 

WHERE DateTimeColumn >= DATEADD(HOUR, -48, GETDATE())

Mysql

WHERE DateTimeColumn > DATE_SUB(NOW(), INTERVAL 48 HOUR)

Upvotes: 9

Related Questions