How to select specific dates in PostgreSQL?

Question

My table:

create table example
(
        code           varchar(7),
        date           date,
CONSTRAINT pk_date PRIMARY KEY (code)
);

Dates:

insert into example(code, date) 
values('001','2016/05/12');
insert into example(code, date) 
values('002','2016/04/11');
insert into example(code, date) 
values('003','2017/02/03');

My problem: how to select the previous dates to six month from today ?

In MySQL I can use PERIOD_DIFF,but, in PostgreSQL?

Connected Wanderer · Accepted Answer · 2016-04-04 13:07:44Z

2

You can try INTERVAL instruction :

SELECT date
FROM example
WHERE date < CURRENT_DATE + INTERVAL '6 months'
AND date > CURRENT_DATE;

You will get the dates from today to six months.

edited Apr 4, 2016 at 13:07

answered Apr 4, 2016 at 13:01

Connected Wanderer

3132 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

How to select specific dates in PostgreSQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related