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: (view raw or whole thread)
Lists: pgsql-novice
On Friday 7 July 2000, at 21 h 3, the keyboard of "sandis" <sandisj(at)parks(dot)lv> 

> 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-2015 The PostgreSQL Global Development Group