Skip site navigation (1) Skip section navigation (2)

Re: date comparison

From: Stephane Bortzmeyer <bortzmeyer(at)pasteur(dot)fr>
To: "sandis" <sandisj(at)parks(dot)lv>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: date comparison
Date: 2000-07-10 11:36:53
Message-ID: 200007101136.NAA02643@ezili.sis.pasteur.fr (view raw or flat)
Thread:
Lists: pgsql-novice
On Friday 7 July 2000, at 21 h 3, the keyboard of "sandis" <sandisj(at)parks(dot)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;



In response to

pgsql-novice by date

Next:From: Thomas KrebsDate: 2000-07-10 12:49:57
Subject: Re: newbie problem on creating table
Previous:From: sandisDate: 2000-07-10 09:00:54
Subject: where can i find more help and sample code?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group