Postgres Pro
Downloads
Home   >   mailing lists

Re: Fw: Count rows group by time intervals - Mailing list pgsql-novice

From Loredana Curugiu
Subject Re: Fw: Count rows group by time intervals
Date
Msg-id 1c23c8e70705090810k34dc7965w7bb935e6fa62f286@mail.gmail.com
Whole thread Raw
In response to Re: Fw: Count rows group by time intervals  ("Loredana Curugiu" <loredana.curugiu@gmail.com>)
List pgsql-novice
Tree view
If I use
 SELECT date_part( date-'2007-01-01' )::int % 2
 FROM table
I get zeros and ones.


pgsql-novice by date:

Previous
From: "Loredana Curugiu"
Date:
Subject: Re: Fw: Count rows group by time intervals
Next
From: "Oliveiros Cristina"
Date:
Subject: Re: Fw: Count rows group by time intervals