Re: [SQL] Extracting data by months

[Karel Zak]

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