Re: date comparison

On Friday 7 July 2000, at 21 h 3, the keyboard of "sandis" <sandisj@parks.lv>
wrote:

> SELECT something FROM mytable WHERE MONTH('timestamp_field')=07
>                AND YEAR('timestamp_field')=2000 LIMIT 1;

SELECT * FROM conferences WHERE date_part('year', date_begin) = 2000
                          AND date_part('month', date_begin) = 7;