Re: date comparison - Mailing list pgsql-novice

From Stephane Bortzmeyer
Subject Re: date comparison
Date
Msg-id 200007101136.NAA02643@ezili.sis.pasteur.fr
Whole thread Raw
In response to date comparison  ("sandis" <sandisj@parks.lv>)
List pgsql-novice
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;



pgsql-novice by date:

Previous
From: "Poul L. Christiansen"
Date:
Subject: Re: MS Access conversion utility
Next
From: "Thomas Krebs"
Date:
Subject: Re: newbie problem on creating table