How do I retrieve data that is within a specific date range?

Question

I want to retrieve data from within 60 days of a created_at date. Here are two columns: SomeValueColumn, created_at. I only want data for each row of the SomeValueColumn WHERE the created_at date is within 60 days.

What is the most efficient way of doing this? I can't seem to figure out the where statement.

Aaron Dietz · Accepted Answer · 2016-07-11 20:14:19Z

1

Use the INTERVAL function:

SELECT SomeValueColumn, Created_At
FROM   YourTable
WHERE  Created_At > CURRENT_DATE - INTERVAL '60 days'

answered Jul 11, 2016 at 20:14

Aaron Dietz

10.3k1 gold badge17 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Maarten Kieft · Accepted Answer · 2016-07-11 20:09:30Z

0

You need a where statement like this:

DATEADD(DAY,-60,GETDATE())

So your query will look like this:

SELECT SomeValueColumn, created_at FROM table WHERE DATEADD(DAY,-60,GETDATE())

answered Jul 11, 2016 at 20:09

Maarten Kieft

7,1853 gold badges31 silver badges37 bronze badges

1 Comment

Maarten Kieft Over a year ago

Oops, I didn't see the postgress tag, ignore this answer. Its for mssql

Collectives™ on Stack Overflow

How do I retrieve data that is within a specific date range?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related