Re: Extracting data by months

On Fri, 4 Aug 2000, Sandis wrote:

> I do it like this:
>
> SELECT datums FROM jaunumi
> WHERE date_part('year',datetime(datums)) = '2000' AND
> date_part('month',datetime(datums)) = '08';
>
> Where datums is a timestamp field.

Or (in 7.0):

SELECT datums FROM jaunum WHERE to_char('YYYY/MM', datums) = '2000/08';

....becuase it more simple and it *will faster*.

Karel