CODEWITHSUNDEEP
sqlpostgresql
Abhishek
Abhishek

Reputation: 380

generate date of week interval in postgres

I want a series in PostgreSQL which gives the date of every week interval before that date

Examples

1)  Date Selected is 05/31/2013
    So the series must be :
    05/31/2013 
    05/24/2013
    05/17/2013
    05/03/2013
    04/26/2013

2)  Date Selected is 05/20/2013
    So the series must be :
    05/20/2013 
    05/13/2013
    05/06/2013
    04/29/2013
    04/22/2013

What I have done:

SELECT * 
FROM generate_series('2013-05-03 00:00'::timestamp,'2013-05-31 12:00', '1 weeks')

Upvotes: 3

Views: 4151

Answers (1)

vyegorov
vyegorov

Reputation: 22905

Is it what you're after? 

SELECT *
  FROM generate_series('2013-05-31 12:00'::timestamp,
                       '2013-05-03', '-1 weeks');

Upvotes: 7

Related Questions