Re: Extracting data by months - Mailing list pgsql-sql

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