| From: | Stephane Bortzmeyer <bortzmeyer(at)netaktiv(dot)com> |
|---|---|
| To: | mixo <mixo(at)beth(dot)uniforum(dot)org(dot)za> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: dates |
| Date: | 2002-04-08 12:32:57 |
| Message-ID: | 20020408123257.GA1307@staff.netaktiv.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Apr 05, 2002 at 04:14:15PM +0200,
mixo <mixo(at)beth(dot)uniforum(dot)org(dot)za> wrote
a message of 13 lines which said:
>
> I have a table with column of time stamps of when a row entry was created.
> How can I get the entries of a particular day (date) from these without
> having to
> resort to 'where creation_date like somedate' ?
select * from MYTABLE where extract (day from MYDATECOLUMN) = extract (day from timestamp '2001-03-08') ;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephane Bortzmeyer | 2002-04-08 12:37:06 | Seq. scan when using comparison operators, why? [netaktiv.com #150] |
| Previous Message | tony | 2002-04-08 11:30:00 | Re: I18n & Pgaccess ( & psql) |